Synchronization script can’t be created when using CLI in ApexSQL Data Diff (4296690)
This article explains about the problem that ApexSQL Data Diff has when using Command Line Interface (CLI) ... Symptoms ... After setting up usual switches and options for comparing and synchronizing databases in CLI for ApexSQL Data Diff, the process can’t be finished.
“Check-in failed Source control error: Cannot checkin pending changes” error (4216322)
Symptoms ... “Check-in failed Source control error: Cannot checkin pending changes” error can be encountered during the synchronization to the Team Foundation Server repository, when the synchronization script exceeds 300 MB in size This error can be also encountered if the connection speed between local machine and Team Foundation Server hosting service is slow.
The Out Of Memory exception is encountered when comparing large databases in ApexSQL Data Diff (4211566)
Symptoms: ... If very large databases are compared, in some cases, the memory limitation of the application may be exceeded. ... If so this will produce an Out Of Memory error. ... Due to how data is compare in memory, there will always be a finite amount of data that can be compared based on the memory available to the process.
“Cannot insert the value NULL into column 'ColumnName', table 'TableName; column does not allow nulls. INSERT fails.” error (4301339)
INSERT fails.” error is encountered when running ApexSQL Data Diff synchronization script. ... Workaround ... This problem is resolved in the following way. ... First, a table that is mentioned in the error report need its structure to be checked to see if the columns are set to allow NULL, since it wouldn’t be possible to insert NULL value into a cell where it is not allowed.
How to create custom schema mappings (4213459)
This article explains how to use the Schema mapping (aka owner mapping) feature to map objects with the same structure but different schema names ... Summary ... This article explains how to use the Schema mapping (aka owner mapping) feature to map objects with the same structure but different schema names.
How to enable application logging (4214943)
Summary ... This article explains how to enable application logging and track down changes in the application. ... Applies to ... Summary ... This article explains how to enable application logging and track down changes in the application.
Utilizing the “no differences detected” return code in ApexSQL change management console applications (4296711)
This article explains the usage of the 102 – No differences detected return code when the compared data sources are equal. ... This article explains the usage of the 102 – No differences detected return code when the compared data sources are equal.
How to filter compared objects using the Inc/Exc switch with the ApexSQL Data Diff CLI (4218175)
This article explains how to compare and synchronize certain objects by using switches in the CLI for ApexSQL Data Diff. ... Description ... The Command Prompt has to be run as administrator so that the CLI (Command Line Interface) can be accessed with all privileges to execute any command.
How to export specific tables/rows as HTML and HTML simple reports (4211669)
ApexSQL Data Diff provides comprehensive and customizable HTML and HTML simple reports that can be set to correspond to a set of specific conditions. ... Description Before moving to mentioned reports, there are a couple of options that can be set for the exporting reports.
How to perform custom object mapping in ApexSQL Data Diff (4299097)
This article explains how to use the Object mapping feature in ApexSQL Data Diff to map the specific objects in a database for comparison and synchronization in SQL Server. ... Description ... Object mapping is used for a custom mapping of tables and indexed views with different names and schemas.
Custom database comparison keys (4216069)
This article explains how to use the Custom comparison keys in ApexSQL Data Diff in order to uniquely identify and compare table rows without a primary key or unique constraint/index. ... Description
How to remove ApexSQL tools from SQL Server Management Studio (4211090)
This article will explain how to remove the SQL Server Management Studio add-in component from standalone ApexSQL tools like ApexSQL Compare, ApexSQL Data Diff, ApexSQL Decrypt, ApexSQL Diff, ApexSQL Doc or ApexSQL Generate, without uninstalling the tool completely from the machine.
Using the Row filter option in ApexSQL Data Diff (4213276)
Applies to ApexSQL Data Diff Summary This article explains how to use the Row filter option in ApexSQL Data Diff to limit the comparison in SQL Server to a specific subset of rows. ... Description The Row filter option allows filtering database rows and including or excluding some of them from the SQL Server comparison and synchronization process, depending on the defined condition.
Using regular expressions in ApexSQL tools (4216046)
This article explains how to use .NET framework regular expressions in ApexSQL tools. ... This article explains how to use .NET framework regular expressions in ApexSQL tools. ... Description ... A regular expression is a string that is used to describe or match a set of strings, according to certain syntax rules.
Benefits of using the Row filter in SQL database comparison (4211144)
Summary This article explains benefits of using the Row filter in SQL database data comparison. ... Description If there is a need to compare a predefined range of data in two SQL tables located in different databases and on different servers, but these tables have more than 100 million records, a full table comparison would be too time-consuming and could deteriorate the network and server performance.
Inventory of ApexSQL Data Diff and ApexSQL Diff output files (4296703)
This article explains inventory of the ApexSQL Data Diff and ApexSQL Diff output files, their names, types, and descriptions. ... This article explains inventory of the ApexSQL Data Diff and ApexSQL Diff output files, their names, types, and descriptions.
How to execute large SQL scripts (4213449)
This article shows how to execute large scripts created by ApexSQL tools which are too big to be opened or executed by SQL Server Management Studio Query Editor ... Description ... Synchronization scripts, undo and redo scripts, and recovery scripts generated by ApexSQL tools can be so big that SQL Server Management Studio Query Editor can't open and execute them
How to setup an e-mail alert system for ApexSQL tools (4214934)
Summary This article describes how to create e-mail alert system for ApexSQL tools using PowerShell in order to send e-mails upon executed ApexSQL tool providing the necessary information. ... Summary This article describes how to create e-mail alert system for ApexSQL tools using PowerShell in order to send e-mails upon executed ApexSQL tool providing the necessary information.
Four ways of handling database/login credentials during automated execution via the CLI (4292458)
Summary ... This article explains how to automate the execution of ApexSQL tools via the CLI while handling the passing of database credentials or using Windows authentication. ... Applies to ... Summary
How to synchronize data between databases with different settings (4295630)
The behavior of DATETIME or SMALLDATETIME types of data can be influenced by the client, server, and/or the operating system settings. ... To illustrate, three databases located in three different countries will be used.
Setting up the Source control wizard for a Git repository (4216313)
This article explains how to set up the Source control wizard for the Git repository in ApexSQL applications. ... Description ... A prerequisite for setting up the Source control wizard in ApexSQL application is creating a repository on one of the hosting services.
ApexSQL Data Diff Command Line Interface (CLI) switches (4216068)
.polje1 { ... border: none !important; ... width: 200px !important; ... font-family:'Courier New'; ... font-weight: bold; ... .polje2 { ... width: 420px !important; ... <p><b>Applies to</b>
How to use a project file in the CLI (4211094)
This article explains how to use a project file in the CLI. ... This article explains how to use a project file in the CLI. ... Description ... Instead of setting the value of switches directly in the CLI, setting up a project file through the GUI with the desired options pre-set, saves time, because it requires only one switch to be used in the CLI.
Minimal SQL Server permissions for ApexSQL Developer tools (4216304)
Description ... In order to properly use ApexSQL Developer tools certain minimal SQL Server permissions need to be allowed on databases that are being used. ... Required permissions ... Required permissions are public SQL Server role and the public role membership that need to be configured along with the login.
Save project as automation script (4213614)
Most ApexSQL tools have a CLI switch to consume a project file. ... This allows for the simplicity and ease of using a project file but also for unattended automation of a batch file or a PowerShell script.
新产品关联性