[Eug-lug] mysqldump equivalent for MS SQL 2000?

[Ben Barrett]

http://davidhayden.com/blog/dave/archive/2006/01/13/2692.aspx
or even
http://mdid.org/mdidwiki/index.php?title=3DHow_to_export_data_from_SQL_Serv=
er_2000_to_XMLif
you re-imported,
but I'm guessing you want table definitions too.

or:  Can you restore a table backup to a differently-named table?

sorry, that's all I got

   ben


On 10/30/06, Quentin Hartman <qhartman at gmail.com> 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!
>
> --
> -Regards-
>
> -Quentin Hartman-
> _______________________________________________
> EUGLUG mailing list
> euglug at euglug.org
> http://www.euglug.org/mailman/listinfo/euglug
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://euglug.org/pipermail/euglug/attachments/20061030/69c5aa4f/attac=
hment.htm