Data Transformation Services in Enterprise manager will handle that in a
relatively simple way.
Matthew Jarvis wrote:
I'm posting this on behalf of an associate...
"I'm needing to copy all of the contents of one MS SQL 2000 server to
another. In MySQL, I'd just "mysqldump --all-databases" and get on
with life. However, there doesn't seem to be an equivalent tool for MS
SQL that will do everything on the server and get the stored
procedures and auth info and whatnot. The DTS built in to MS SQL 2000
could work, but that requires explicitly naming each database I want
to copy, which won't be feasible in the long run because the number of
databases on this machine is constantly growing. All the commercial
third-party applications I've looked at are similarly
database-centric, with no good way to "give me everything" in any sort
of scriptable way. I want a very stupid tool, and everything I've
found tries to be too smart! "
--
Richard Kaye
Artfact/RFC Systems
Voice: 617.219.1038
Fax: 617.219.1001
For the fastest response time, please send your support
queries to:
Technical Support - [EMAIL PROTECTED]
Australian Support - [EMAIL PROTECTED]
Internet Support - [EMAIL PROTECTED]
All Other Requests - [EMAIL PROTECTED]
---------------------------------------------------------
This message has been checked for viruses before sending.
---------------------------------------------------------
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
