Copy to a new database

The Copy to a new database capability provides a way to copy all of the data in one database into another database on the same or different computers. The database types can be the same or different. This is useful, for example, when you have a test environment and you want to copy all the data to another database.

The following picture shows the Copy to new database window. You can click on "hot spot" areas in the picture below to get detailed information about buttons, controls and fields.

Source Database Connect Info

Database Type

Select one of the supported database types.

Example Connect String

The example shown in this field is displayed based on the selection in the Database Type drop down list. The example can help you configure the connection string used by the Remote Agent to connect to the database server type used. When the Datebase Type is selected the example connect string template is copied into the Example Connect String field and the Connect with field if this field is empty . You can then modify the information in the Connect with field so that it contains the correct information to connect to your database server. Note that you should not include the user id and password in the Connect with field. This information is provided and configured into the connection string by the Remote Agent based on the values placed into the User ID and Password fields.

Connect With

The actual connection string used by SmartBatch to connect to the database product selected under the Database Type drop down list. Make sure you try the Test Connection button to make sure the value entered in this field is configured correctly.

User ID

The User ID associated with the Password used to connect to the database server used to host the SmartBatch configuration.

Password

The password associated with the User ID used to connect to the database server that hosts the SmartBatch configuration.

SQL Prefix

This is an optional input field and is typically left blank. Use this value to prepend any SQL commands to each SQL statement that is sent to the database.

Test Connection Button

Uses the connection information provided to connect to the Database Type selected. If the connection is successfully established, a message box will be displayed indicating success. Otherwise, an error message will be displayed.

Target Database Connect Info