Data Projects
To create a new data project, select New Data Project from the File
menu. This will open the Data Project dialog where you can enter a
project description and define your source and destination databases.
The destination database is the database that you want to change in
order to make it identical to the
source database. After comparing the databases, you will be able to
generate a synchronization script to render the destination database
identical to the source database.
Once the project is created, you will see a list of tables that are
ready to be compared. Teratrax Database Compare maps the source tables
to the the destination tables based on table name automatically so you
can create and compare a project in a few clicks. To map a source table to
a different table name in the destination database, use the dropdown in
the destination column to select a different table. Tables that cannot
be compared (For example, a table that lacks a primary key) will be
flagged with a warning sign to indicate that they will not be compared.
After selecting the tables you want to compare, you can
run the comparison by selecting Compare from the Actions menu. Once the
tables have been compared, select Sync Script (Project) from the
Actions menu to generate the SQL script needed to render the destination
database identical to the source database.
Data Synchronization
Once the project is compared, you can click on
Sync Script (Project) to generate the necessary SQL statements
to synchronize the destination
database and make it identical to the source database. If you want to
view the differences between the source and destination databases,
navigate to the node representing each table and expand it. Note that
you cannot expand these nodes before you run compare. Under each table,
you will see four sub nodes:
-
Identical Rows: table rows that are identical.
These rows will not be part of the synchronization script.
-
Update In Destination: table rows that are
different between source and destination databases. UPDATE statements
will be included in the synchronization script to make these rows
identical in the destination database.
-
Insert In Destination: table rows found only in
the source database. INSERT statements will be included in the
synchronization script to add these rows to the destination database.
-
Delete From Destination: table rows found only in
the destination database. DELETE statements will be included in the
synchronization script to remove these rows from the destination
database.
The synchronization script should always run on the destination to
make identical to the source database. Rows are compared based on
primary keys to determine whether they are identical or different.
Tables that are found in the source database but not in the destination
database will not be listed. These tables can be detected in a schema
projects.
Data Project Dialog
The Data Project dialog allows you to create a new data project or
edit an existing data project. the following is a list of items in the
dialog:
Description
The description associated with the project acts like
a name to identify the project in the Project Explorer. Descriptions are unique in
the Data Project node in Project Explorer.
Source Database
- Server: server name or IP address of the SQL Server instance where
the source database resides (For example, ServerName or ServerName\<instance
name> for named instances).
- Windows Authentication: configures Teratrax Database Compare to
connect to the source database using a your Windows user account.
- SQL Server Authentication: configures Teratrax Database Compare to
connect to the source database using a SQL Server login and password.
- Login: the login name used if SQL Server Authentication is
selected.
- Password: the password used if SQL Server Authentication is
selected.
- Database: the source database or master database. Teratrax
Database Compare will examine this database to determine how the
destination database should look like.
To drop down the list of databases using the keyboard, tab into the
database dropdown and press Alt+Down Arrow.
Destination Database
- Server: server name or IP address of the SQL Server instance where
the destination database resides (For example, ServerName or ServerName\<instance
name> for named instances).
- Windows Authentication: configures Teratrax Database Compare to
connect to the destination database using a your Windows user account.
- SQL Server Authentication: configures Teratrax Database Compare to
connect to the destination database using a SQL Server login and password.
- Login: the login name used if SQL Server Authentication is
selected.
- Password: the password used if SQL Server Authentication is
selected.
- Database: the destination database. This is the database that you
want to render identical to the source database.
To drop down the list of databases using the keyboard, tab into the
database dropdown and press Alt+Down Arrow.
|
