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 - techsupport (AT) rfcsystems D.OT com
Australian Support - ausupport@rfcsystems.com
Internet Support - websupport (AT) rfcsystems D.OT com
All Other Requests - request@rfcsystems.com
---------------------------------------------------------
---------------------------------------------------------
©2006 Richard Kaye |
