SQL 2000 Data Transfer is a Snap with SQL 2005 - Registering the networked SQL 2000 Server
(Page 2 of 7 )
In order to make life easier, the first task to be accomplished is to register a server, this one on the network. In SQL 2005 you have a new set of windows to contend with for registering the new server. It is important to know the authentication information required. First log on to the SQL 2005 server instance, herein called Hodentekmysorian, where Hodentek is the machine name and mysorian is the SQL 2005 server instance as shown in the next picture. Substitute mentally that "Yen" is same as "" (that's a problem I still need to fix). Click on connect. You will see the server and its objects in the object browser on the left hand side.
Now highlight the server instance to which you got connected and right click to choose Connect again. In the login box click on Browse for more.... This brings up the next Browse for Servers screen where the tabs give access to local and networked servers. Change the tab to Network. Depending on the connection it will take a short time before you see the listing of all network servers. It is assumed that you have started the SQL server service on the networked machines you are attempting to connect.
The connection to server XPHTEK(8.0) is made and the OK button is clicked. This brings us to the login screen for the XPHTEK machine as shown. Choose SQL Authentication, and after entering the User Name and Password click on the Connect button.
With this task completed you are connected to the XPHTEK server which now appears as a new node in your object browser as shown. It's nice to see that you also know to what version of SQL server you are connected. Of course you can expand all the nodes and verify the objects you want to use before using them.
Next: Exporting from SQL 2005 to SQL 2000 server >>
More MS SQL Server Articles
More By Jayaram Krishnaswamy
