Using DTS: Import From/Export To a Non-Microsoft Database - Export a table from MS SQL to SQL Anywhere
(Page 4 of 5 )
We have seen in an earlier tutorial how to invoke the Import/Export wizard. You could start this wizard from the shortcut on Start ->All Programs->MS SQL Server-> Import Export Data. This will actually start the C:\Program Files\Microsoft SQL Server\80\Tools\Binn\dtwiz.exe program. It could be started from the command line as well. This starts an instance of the Import/Export wizard as shown in the following image:
Click Next to pick the source of data. Since we will be exporting from the local SQL Server, we choose the pubs database on the local server as shown in the next screen shot.
Click Next> to open the next screen, where we pick a destination. We choose from the drop-down the Sybase Adaptive Server anywhere Provider 9.0. We may need to connect to the SQL Anywhere server (assuming it is still running). Click on the Properties...button.
This opens up the next screen where you enter the credentials one more time. The only information needed is as shown in this screen. You may test to verify that you succeeded in the connection.
Close the message box by clicking OK and then click Next>. This will get you to the following screen showing that you are ready to move the table from MS SQL to SQL Anywhere.
When you click Next> to the above screen you will open the next screen where you pick the table to move. We will be moving the [pubs].[dbo].[publishers] table to the SQL Anywhere.
Place a check mark against this. If you want you may see the data by hitting the Preview button. Now click Next>. You will see the following screen.
This is essentially as the screen succinctly puts it, the Save, Schedule, and replicate package screen. We will discuss elsewhere some of these options. For now, place a check mark against the Save DTS Package option at the default SQL Server and click Next>. This brings up the screen where you need to save the package with a name. Here it is saved to Export ToSqlAny.
Click Next> to open the next screen. This completes the wizard's main tasks in exporting the table.
Click finish. This starts the export as seen in the next screen. The publishers table can now be found in the Sybase's asademo.db database.
Now we open up the Sybase Central Administrative interface and refresh all objects. We see the publishers table in the asademo.db database showing that the process was successful.
Next: Import a table from SQL Anywhere to MS SQL >>
More MS SQL Server Articles
More By Jayaram Krishnaswamy
/ 13 
