Database Migration

This topic is for SmartBatch32 customers that want to use SmartBatch.  The migration from SmartBatch32 to SmartBatch is supported but you must use SQL Server as the destination database.  Future versions of SmartBatch will not provide support for migrating SmartBatch32 databases as support for SmartBatch32 was dropped in May of 2005.

SmartBatch comes with a program that allows you to move your data from one copy of the database to another.  It is used when you upgrade to a newer version of SmartBatch to move or migrate your data from the older version of a database to the new version. This program is called the SmartBatch Database Migration Program.  

To run the Database Migration program:

1.From the Start menu, select Programs > OnLine ToolWorks>SmartBatch > Database Management

or

1.Double-click DbMigration.exe in the folder where SmartBatch was installed.

You will be prompted for the name of the source and the destination data sources. The source Data Source is your existing data source. This may be the sb32.sdb file supported in previous versions of SmartBatch. The destination data source is the name of the new data source that the information from your old data source will be transferred.

Creating A Data Source

A data source is automatically created at the time SmartBatch is installed. You can create a new database in SQL Server by selecting the <new> option in the Database Name drop down under the Destination database information.

Note:  Migrating data from SmartBatch32 to SmartBatch can only be to a SQL Server data source.

Migration Processing

The database migration program will take all information other than status and log records and transfer this data to the new database.  

The following pictures show the Database Migration Program window and options. You can click on "hot spot" areas in the pictures below to get detailed information about buttons, controls and fields.

Database Migration (.SDB source database)

 
  

Source database

Database Option

The source database must be a .sdb file from a previous version of SmartBatch or a SQL Server database.

File Name:

The path and file name of an existing SmartBatch32 database file. This file is from a SmartBatch version prior to 4.0. The file must be on the same computer where the SQL Server is running. It is possible that the SQL Server is on a computer other than where the Administrator is running and where the Executive Server is installed. To migrate from an existing sb32.sdb, you must make sure that this file resides on the computer where the SQL Server is running.

 

Destination database

Database Type

Identifies the type of database that will be used to host the SmartBatch configuration. For example: SQL Server.

User ID

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

Delete Source Database

If this option is selected, the source database will be deleted when the migration completes successfully. If the migration is not successful for any reason, the source database will not be deleted.

Password

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

Database Name

Shows a list of databases associated with the SQL Server information entered.

Refresh Button

Refreshes the window or control by obtaining the latest information from the SmartBatch database.

 

Show Status Button

Click this button to display the status associated with the database migration. The status provides detailed information on the results of the migration. The status can be displayed or hidden using this button.

 

Use the .sdb database file when migrating from a previous version of SmartBatch where were using the default database at the time of the sb32.sdb file. Your previous release must have been 3.20c or above.

Database Migration (SQL Server source database)

 

Source database

Database Option

The source database must be a .sdb file from a previous version of SmartBatch or a SQL Server database.

Database Type

Identifies the type of database that will be used to host the SmartBatch configuration. For example: SQL Server.

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.

Database Name

Shows a list of databases associated with the SQL Server information entered.

Refresh Button

Refreshes the window or control by obtaining the latest information from the SmartBatch database.

 

Destination database

Database Type

Identifies the type of database that will be used to host the SmartBatch configuration. For example: SQL Server.

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.

Database Name

Shows a list of databases associated with the SQL Server information entered.

Delete Source Database

If this option is selected, the source database will be deleted when the migration completes successfully. If the migration is not successful for any reason, the source database will not be deleted.

Rename Database

Renames the database name used in the Destination database to the name used in the source database. The renaming will occur only if the database migration was successful.

Refresh Button

Refreshes the window or control by obtaining the latest information from the SmartBatch database.

 

Show Status

Click this button to display the status associated with the database migration. The status provides detailed information on the results of the migration. The status can be displayed or hidden using this button.

 

If you are migrating from a SQL Server database, use the SQL Server database option for both the Source and Destination databases.