Create SQL script to synchronize schemas of two databases

Settings for creating SQL sync script to synchronize schemas and predefined data of two databases

Create SQL script

Make the synchronization script.

Common script

Make the synchronization script as a common script without links to the concrete target database as far as it is possible.

Append refresh of Views & Inline Functions

See Views and Inline functions.

Carry over data

See Carry over data.

Append

Append a custom script to the synchronization script to do any final steps that the target database needs.

You can select the one SQL file or a script listing file. To create a listing of SQL files just select them in the order of their execution in the Dialog.

Expected files size, [Mb]

The expected size of the synchronization script files.

EXECUTE

Execute the synchronization script on the target database.


Create and recreate dependent objects in SQL Server databases

The algorithm of the SQL script generation takes into account the dependencies between objects of the structure, which guarantees its correct execution in the practical majority of cases.

To build the correct sequence to create, alter, recreate or delete objects in a script, AutosyncDB uses ranking algorithms based on the dependencies between objects, including detection and processing the cyclic dependencies.

During the creation of objects that are dependent on each other SQL Server will produce the warnings:

The module 'x' depends on the missing object 'y'. The module will still be created; however, it cannot run successfully until the object exists.

This is a standard situation when one of the dependent objects is created first.