Category
Versão do produto
Tópico
Subtópico
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.
Exporting schema comparison results into an HTML report (4216226)
Summary ... This article explains how to export schema comparison results into an HTML report and options that can be used before and after exporting results. ... Description ... Once data sources are compared and comparison results are shown use the Export button from the Home tab to export results into and HTML report – this is a user-friendly interactive format.
Setup the minimum rights for ApexSQL Diff user (4214792)
This article explains how to setup the SQL Server login with minimum rights for ApexSQL Diff so that it can run comparison processes and create synchronization scripts but can't execute generated scripts
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.
List of unsupported Azure options for ApexSQL Diff (4214359)
Note that below are listed limitations of Azure V11, which is fully supported by ApexSQL Diff. ... In Azure V12 some of those limitations are resolved, but ApexSQL Diff currently offers basic Azure V12 support, while work is underway to implement full Azure V12 support.
Configuring ApexSQL Diff to work with source control data sources (4214847)
This article explains how to configure ApexSQL Diff to work with source control data sources (how to set a source control data source and how to export a live database to a source control repository).
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.
How to compare SSIS packages and export difference results (4210291)
This article explains how to compare SSIS packages and export package difference results. ... Description ... SSIS comparison feature in ApexSQL Diff can be used for comparing different SSIS packages.
ApexSQL Diff – Exporting SQL data sources (4213347)
This article explains all about exporting SQL data sources in ApexSQL Diff. ... SQL compare tool ApexSQL Diff has a feature that allows you to create a SQL database snapshot, as well as using it for comparing and synchronizing with other SQL data sources.
ApexSQL Diff Command Line Interface (CLI) switches (4291782)
Alias: <span style="font-family: Courier New;font-weight: bold;">/scl1</span> ... Format: <span style="font-family: Courier New;font-weight: bold;">/get_sources_by_label_1:<br>"SourceLabelName"</span>
XML schema difference export (4214806)
This article explains XML schema difference export and how to navigate through it, and the Export data sources feature. ... Description ... The XML schema difference export generates an XML file, listing the selected objects from the Results grid, indicating if they are different, identical, or present in one of the data sources.
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.
How to use bitwise set in ApexSQL CLI (4213634)
This article explains how to use the bitwise set switch in the CLI of ApexSQL tools. ... After connecting to SQL Server, and selecting the database, you may choose a combination of objects, and the appropriate bitwise set will be automatically generated.
How to narrow schema comparison and synchronization to affected objects only (4215648)
Summary ... This article explains how to use filtering options in ApexSQL Diff to narrow down schema comparison and synchronization to affected objects only. ... Description ... In cases when schema comparison and synchronization need to be narrowed down to desired objects, ApexSQL Diff offers various filtering options.
How to change SQL object selections for automated processes/jobs (4218217)
Summary ... This article explains how to manipulate with SQL objects that are created in one of data sources after the project file was saved, in automated process. ... Description ... In cases when specific automated processes are set up, like the ones described in the following articles:
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
Exporting schema comparison results to Excel (4219381)
Applies to: ApexSQL Diff Summary ApexSQL Diff has an export option to easily customize with various options. ... Here is an explanation how to export schema comparison results into an Excel report and what options can be selected:
Exporting schema comparison results into a simple HTML report (4292424)
Summary ... This article explains how to export schema comparison results into an HTML simple report and options that can be used before exporting results. ... Description ... A report or export of the results of a comparison is a helpful feature.
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.
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.
Associação de novos produtos
- Ferramentas de autoatendimento
- Base de conhecimento
- Notificações e alertas
- Suporte a produtos
- Downloads de software
- Documentação técnica
- Fóruns de usuário
- Tutorial em vídeo
- Feed RSS
- Fale conosco
- Suporte técnico
- Visualizar tudo