I have a rather sizeable SQLServer 2000 database. To work on an issue, I would like to copy just a couple tables into SQL Server 2005 Express. How does one go about this efficiently?
I have a rather sizeable SQLServer 2000 database. To work on an issue, I would like to copy just a couple tables into SQL Server 2005 Express. How does one go about this efficiently?
Sorry, I should have mentioned that I have used DTS in SQLServer 2000 to copy from tables from one DB to another, but in SQL Server Management Studio Express (or in SQL Server Configuration Manager) I do not see any DTS-like tools available.
|||You are right, there are no tools for that. What about either doing a backup / restore on the databases OR do a manally SELECT INTO with using linked servers ? Another option would be to script the structure and then script the data from the table and execute the data script on the other server.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||I would like to do a SELECT INTO... but could you enlighten me on how to link servers?|||Sure, but might have a look in the BOL about adding linked servers. In common if you don′t have the GUI to administer linked servers you can use the procedure sp_addlinkedserver and others around it, mentioned in the BOL.
If you are not sure about that, do not hesitate to come back. :-)
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de|||I was hoping to get a bit more detail. Plus I do not understand what your last message was trying to communicate.|||
In case you're still looking, you can find a discussion of Linked Servers here. There are several links at the bottom of the topic that will take you to the specific topics on creating and using Linked Servers.
Mike
sql
No comments:
Post a Comment