[program-l] sql server tables and DTS
- From: "Justin Daubenmire" <justind@xxxxxxxxx>
- To: <program-l@xxxxxxxxxxxxx>
- Date: Wed, 7 Sep 2005 10:42:08 -0400
All.
Simple task but not knowing if there is an accessible way of doing it. Have
a table that I need to copy it and the data over to a separate sql server
2000 db on a different server. Both dbs and tables are in sql server 2000.
I am aware that I can use the DTS and create a package, however, the DTS
package utility in enterprise manager doesn't seem all that accessible to
me.
What method do you all use to copy a table and its data over to a new
server/db?
Again, both dbs and tables are sql server 2000 and just needing to do a
simple copy from db 1 over to db 2 on a different server.
Justin
** To leave the list, click on the immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** program-l-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** program-l-request@xxxxxxxxxxxxx with the Subject:- faq
Other related posts: