[program-l] Re: sql server tables and DTS
- From: David Lant <david.lant@xxxxxxxxxxxx>
- To: "'program-l@xxxxxxxxxxxxx'" <program-l@xxxxxxxxxxxxx>
- Date: Wed, 7 Sep 2005 17:10:22 +0100
Hi Justin,
Last time I did this, I used the DTS wizard, and struggled through the
inaccessibility problems. Not pleasant, but achievable if you're prepared
to drink lots of coffee and grind your teeth. <grin>
The other method I use, is to get one of our DBAs to do it. But that
probably isn't an option... <smile>
A final, and slightly long-winded way is to do it in two halves. Right
click the table, and choose the generate script option to script the table
creation. Then, right click the table again, and choose the export wizard,
which is basically the same DTS wizard as before. But this time, simply
choose to export the data to an Access database or some other external
format. Then you can go to the other machine, run the table script to
create the table, and finally import the data from the Access database.
None of these are ideal, I admit. But you might be able to manage somewhere
along the way. If someone does have an alternative method that is
completely accessible, I'll be interested too.
David Lant
I.T. Consultant
Consultancy & Development
ICT Services
Tel: (01392) 382464
Devon County Council accepts no legal responsibility for the contents of
this message. The views expressed do not reflect those of Devon County
Council.
-----Original Message-----
From: Justin Daubenmire [mailto:justind@xxxxxxxxx]
Sent: 07 September 2005 15:42
To: program-l@xxxxxxxxxxxxx
Subject: [program-l] sql server tables and DTS
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
** 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:
