Converting to MSSQL
Database Builder provides a wizard for converting tables into an MSSQL database from any other supported database type. This wizard will convert the table structures from the current workspace's database into an MSSQL database, then move all of the data.
To convert tables from the current workspace's database into an MSSQL database, select Convert to MS SQL Server from the Database menu. This brings up the Conversion Wizard.
Press Next and the Select source tables page will be displayed where you should select the tables that you wish to convert.
The checkbox above the list of tables – Delete original table after conversion of table successfully completed – should be selected if you would like to delete the original tables after successful conversion. If any errors occur during conversion, the original tables will not be removed regardless of the selection you make here.
Once you have selected the tables, click the Next button so the wizard analyzes the selected tables. Click on Next again to continue with the conversion options.
For recnum tables, the Define recnum table conversion page will be displayed listing all the tables identified as recnum tables. The checkbox Convert recnum tables to standard tables lets you choose whether you want to keep the table as a recnum table or not. If you choose to convert the tables to standard tables, you will need to select the indexes for all the tables listed.
After that, click on Next to move on to the Define Conversion Options page. On that page, enter the following:
Server
Enter the location of the server where the MSSQL database you want to access is located.
Database
Enter the name of the database you are connecting to.
User
Enter the user name to be used for authentication when you log on to the MSSQL database.
Password
Enter the password for your user name.
Owner
Enter the name of the table owner to be used for the tables being converted.
Use NT Authentication
Click Use NT Authentication to specify that the provider request a secure (or trusted) connection to the MSSQL Server. When selected, SQL Server uses integrated login security to establish connections using this data source, regardless of the current login security mode at the server. Any login ID or password supplied is ignored. The database administrator must have associated your Windows network ID with a SQL Server login ID.
Store Data in ANSI Format
This option sets the table character format of the resulting table. If checked, data will be stored in ANSI format. If not checked, data will be stored in OEM format.
Convert Definition Only
Check this option if you want to create the tables in MSSQL but do not want to have your data copied over to the MSSQL database.