SQL 2000 Data Transfer is a Snap with SQL 2005 - Exporting from SQL 2005 to SQL 2000 server
(Page 3 of 7 )
The export operation will consist of exporting a table from Northwind on SQL 2005 to the database called TestRun on SQL 2000. Currently there are a couple of tables in TestRun.
To access the SQL Server Import and Export Wizard, right click on the Northwind database in SQL 2005 and choose Export Data from the drop-down menus as shown in the next picture. In SQL 2000 you had a wizard for this task; the same is true for SQL 2005.
The welcome screen appears when you choose the export data option as shown. Read the list of things it can do before you click next. It also creates SSIS packages, as they are called in SQL 2005. Click on Next.
The wizard wants the source of the data and it comes up with the default, a SQL Native client. HODENTEK/MYSORIAN answers this description. There is only one user database called Northwind, and it comes up as a default as shown. Click on the Next button.
Next the wizard requires the destination. It comes up again with the SQL Native client. The default is used. Also since the XPHTEK requires SQL Login, this option is chosen and the information is entered. Now it is possible to choose the database from the drop-down menu as shown. The TestRun database is chosen. Click on the Next button.
Next you need to choose the source table or tables for transporting. Here the customers table is chosen as shown. Click on the Next button.
In the Save and Execute Package screen of the wizard there are a couple of options, fewer than what was available in SQL 2000 (DTS). The choices made are shown. Click on the Next button.
Now you get a number of options to protect your package, the default being the one shown here. This is again slightly different from the one in DTS (review my article or MS BOL).
When you click Next you get to the next screen, where you enter information as to how you want to authenticate. You may also give a name and a description. The package will be saved with that name.
This completes this task and you are almost finished. You will find a list of actions that will be taken when you click finish.
After you click finish the actions will be performed in the order shown in the previous list. You will see a progress bar (so far so good, error court is zero) and the task will finish in a short while.
Next: Oops! there is a problem >>
More MS SQL Server Articles
More By Jayaram Krishnaswamy
