What authentication method does ApexSQL use? (4377107)
When including ApexSQL tools on you environment, it is important to understand the authentication types available. ... <p><img alt="1" src="https://prod-support-images-cfm.s3.amazonaws.com/KB_kA0RP0000002TcD0AU_authenticationapexsql.png"></img></p>
Error encountered: "AADSTS50194: Application 'ea37fbbe-984f-4abd-88c5-8852bd1fe601' (ApexSQL Data Diff) is not set up as a multi-tenant application." (4377493)
Usage of the /common endpoint is not supported for such applications created after '10/15/2018'. ... Use a tenant-specific endpoint or configure the application to be multi-tenant” ... Repro steps:
What's new with ApexSQL Compare and Sync Toolkit for SQL Server (Compare, Data Diff, Diff) 2022.xx ? (4313234)
What's new with ApexSQL Compare and Sync Toolkit for SQL Server (ApexSQL Compare, ApexSQL Data Diff, ApexSQL Diff) version 2022.xx ? <h1> </h1> ... <h1>ApexSQL Compare</h1> ... <div class="col-md-12 col-xs-12 release_notes_box">
ApexSQL Offline Activation Failed to login (4375394)
Merge License files, the file should look like the one from below:
"Column name not valid." error is encountered when trying to create the row filter in the Objects filter tab (4373696)
When trying to create the row filter and selecting the specific objects to compare in the Objects filter tab the "Column name not valid." error is encountered<br>This might happen when two same databases are used for comparison/synchronization In the<strong> Create row filter </strong>window uncheck the "<strong>Use the same filter condition for both objects</strong>" option and click on the <strong>Save</strong> button:<br><br><img id="Immagine_x0020_1" border="0" height="722" src="https://questsoftware.lightning.force.com/sfc/servlet.shepherd/version/download/0686R00000dzgCy?asPdf=false&operationContext=CHATTER" width="905"></img><br><br>
ApexSQL Licensing Permissions Requirements (4373139)
When trying to open ApexSQL 2022 version products, an "Internet connection is required to continue" message comes up. ... ApexSQL 2022 version tool does an internet connection verification process by pinging id.quest.com <br>And needs to reach <span style="font-size: 11.0pt;"><span style="font-family: "Calibri",sans-serif;"><a href="https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Flicensing.ism.quest.com%2F&data=05%7C01%7CNodier.Garcia%40quest.com%7Cebe23feb25c24b96aa7708dbb45616ad%7C91c369b51c9e439c989c1867ec606603%7C0%7C0%7C638302054068664027%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=07YCu2O3DF5omdsa8njCOb9hDj%2Flsdo02nXJzjwJvp8%3D&reserved=0"
How to commit and/or update SQL Server database static data to a source control repository (4242974)
Tables, a mechanism needs to be created to identify only those tables designated as “static” (see below) and to come up with a reproducible process, that will <strong>Commit</strong> the data in these tables to source control.
How to apply static data under source control to a SQL Server database (4240498)
How to apply static data under source control to a SQL Server database "<h2>Prelude</h2> <p> In the <a href="" target="_blank">Understanding SQL Server database static data and how it fits into Database lifecycle management</a>, we covered topics from the basics (what is the static data, why it is used), followed by the explanation of how to version control the static data, meaning how to initially commit, how to track changes and how to apply static data from SQL source control to a database.
Automatically comparing and synchronizing data changes in a SQL Server database (4312095)
tab, so that all options set can be saved into the project file that will be used in the <a href="" target="_blank">automation</a> process</p> <p><img style="" src=""></img></p> </li><li><p>Click the <strong>Synchronize </strong>button on the <strong>Home</strong> tab to initiate the synchronization wizard</p></li><li><p>The synchronization process is the same as in <a href="" target="_blank">ApexSQL Diff</a>, except in ApexSQL Data Diff there is no step for including dependent database objects
How to automatically pull SQL Server database objects from a shared script folder to a local database (4297228)
How to automatically pull SQL Server database objects from a shared script folder to a local database "<h2>Challenge</h2> As it was explained in article on <a href="" target="_blank">How to automatically compare and synchronize SQL Server database objects with a shared script folder</a>, this article will explain the solution for the reverse process, when changes needs to be pulled from a shared script folder to a local database.
How to activate ApexSQL software manually (4216052)
To activate an ApexSQL product online, a Hardware ID and a product activation key are needed. ... To manually activate an ApexSQL product online: ... Navigate to ‘ Product activation’ web page ... Select the ApexSQL product to be activated from the ‘Product’ pick list and the appropriate product version from the ‘Version’ pick list
SQL Server bulk copy and bulk import and export techniques (4277577)
SQL Server bulk copy and bulk import and export techniques "<p> Sometimes, it is necessary to export or import large amounts of data into or out of a database. ... Those operations are called bulk export and import operations.
How to migrate a SQL Server database to a newer version of SQL Server (4253433)
How to migrate a SQL Server database to a newer version of SQL Server "<p> DBAs are well aware that downgrading a SQL Server database cannot be done out of the box. ... Even when the compatibility level of the database that needs to be migrated to an older SQL Server version matches that version, the backup can’t be simply restored.
How to restore a SQL Server database backup to an older version of SQL Server (4261628)
How to restore a SQL Server database backup to an older version of SQL Server "<p>If there was need to restore a SQL Server database backup to an older version of SQL Server there was ""greeting"" with error messages along the lines of:</p>
How to automatically compare and synchronize multiple databases on different SQL Server instances (4321646)
As time goes by, a lot of schema and data changes are made on QA databases on daily basis that require to be in sync with Production databases. ... </p> <p> ... To keep everything in sync, there should a system that would be either triggered or scheduled to run the comparison of all SQL databases and synchronize the ones were changes are detected.
Multiple SQL Server data recovery options (4312504)
In the past two weeks we had some interesting Solution center articles describing Microsoft SQL Server topics – each described as the problem (or the challenge) users may encounter with SQL Server data recovery
How to compare and synchronize databases programmatically (4247769)
They both include the command line interface which provides the exact same options, and which you can use to schedule unattended comparisons and synchronizations</p> <br><p>But, what can be done when the features that the GUI and CLI provide are simply not enough?
Recover deleted SQL data from a backup or from online database files (4320865)
Recover deleted SQL data from a backup or from online database files "<p>Recovering DELETED records is something we would all like to avoid, but no matter how careful we are, it can come to that.
How to automatically compare and synchronize SQL Server database objects with a shared script folder (4318035)
How to automatically compare and synchronize SQL Server database objects with a shared script folder "<h2>Challenge </h2> <p> In some cases, source control systems are not an option for a particular SQL developer team, due to cost concerns, lack of approval etc., but the requirements for such a system, or close approximation, for managing changes across the developer team can still be a priority.
The application adds columns in the synchronization script when creating a clustered columnstore index (4216276)
This article describes an issue in ApexSQL Diff when creating a clustered columnstore index ... Summary ... When creating a clustered columnstore index in ApexSQL Diff the synchronization script will be generated with the wrong syntax.
“Connection was failed with message: ‘The executable did not complete within the allotted time'” message (4293576)
“Connection was failed with message: ‘The executable did not complete within the allotted time'” message can be encountered during the recomparison after synchronizing to the Mercurial source control repository, when the synchronization script exceeds 300 MB in size.
"Objects <object_type>.<schema>.<object_name> are not compared yet" (4214951)
This article explains what to do if you encounter the"Objects .. ... are not compared yet" error message ... Symptoms ... If user tries to exclude any object from the comparison process via the Object filter when configuring the project, the error is encountered
The synchronization script is generated with errors when synchronizing a specific database with an empty database as a destination (4211483)
Description ... This article describes an issue when a database that contains a table or an indexed view that has a FULLTEXT INDEX is synchronized with an empty database. ... The generated synchronization script contains errors.
Loading a project file saved by ApexSQL Diff 2012 or previous version in ApexSQL Diff 2013 resets and blocks the Object filter and Schema mapping features (4211415)
Symptoms ... When user loads .axds project file created in ApexSQL Diff 2012 or an older ApexSQL Diff version, ApexSQL Diff 2013 will reset the Object filter and Schema mappings settings stored within the project file.
Compare It! says it is unregistered (4297082)
Summary ... This article discusses the use of Compare It! as an optional 3rd party add-in for ApexSQL Diff. ... We neither develop it nor distribute free keys for it anymore ... Resolution ... This product isn't necessary since all Compare It! functionality is included in ApexSQL Diff itself (in the Script difference view pane).
新产品关联性