SQL 2000 Data Transfer is a Snap with SQL 2005 - Exporting from SQL 2000 to SQL 2005 server
(Page 6 of 7 )
All the tables from the "pubs" database on XPHTEK will be exported to the SQL 2005 Server. Some of the steps are not shown because they are the same ones we used before, except that the data now comes from XPHTEK. You need to provide the authentication and the database that you want the tables to come from, in this case "pubs." When you click Next, the destination dialogue shows up as shown.
SQL 2005 server has just one database, Northwind. You want the destination to be a new database called Xpubs. You can create the new database Xpubs by clicking on the New... button.
Here you will be able to set the data file and log file sizes and their growth rate. Clicking Next will create the Xpubs database when the package is run.
Again, some screens may have been skipped, but when it comes to choosing the table to be transferred you may select all of them. This interface looks similar to the one in SQL 2000. Instead of the Transform button you have an Edit button for each of the tables. In this tutorial just the default is accepted.
Clicking next and pursuing the wizard to the end finishes the package.
After running the package the new database Xpubs appears in mysorian's node as shown.
Next: Where is the package? >>
More MS SQL Server Articles
More By Jayaram Krishnaswamy
