SQL 2000 Data Transfer is a Snap with SQL 2005 - Modifying the transport
(Page 5 of 7 )
This can be easily done by clicking the <back button a couple of times until you come to the screen shown next. Uncheck the Customers table and check the Products table to be exported.
Clicking on next to the above will bring up the saving of packages dialogue as shown.
Since you want it overwritten, click yes, and you will come to the final screen showing the success of the operation.
If you now look at the TestRun node you will see the Products table in the database. If you don't, just highlight the database and click refresh.
Now click on the Report drop-down menu and send an email about this success to Mike at his company. Outlook Express or the local mail client will pick up the message and deliver it to Mike as shown. I think this is cool. No need to worry about MAPI profile or other things.
Next: Exporting from SQL 2000 to SQL 2005 server >>
More MS SQL Server Articles
More By Jayaram Krishnaswamy
