Quentin Hartman wrote:
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!
Any thoughts or recommendations would appreciated!
Quentin-
I asked around to my MS cronies and I'm afraid to say that so far DTS is
about the best they could come up with....
Matthew S. Jarvis
IT Manager
Bike Friday - "Performance that Packs."
www.bikefriday.com
541/687-0487 x140
[EMAIL PROTECTED]
_______________________________________________
EUGLUG mailing list
[email protected]
http://www.euglug.org/mailman/listinfo/euglug
