Scripts for reverse engineering sql-server 2000

[bjoernebanden]

I'm looking for a command-line tool to autogenerate "create scripts" of all sql-server objects including the replication setup.

Want to schedule an automatic generation of "create scripts" every week, for backup reasons. This way it's easier to restore/recover human error, ie regarding accidently dropping of a replication, or deleting a user a.s.o.

I don't want to use EM, because me and my colleages can forget to right-click-scripting through EM, after a change.
Better to due it automaticly.

 

[ptheriault]

Speed Change Mangager by Quest will do that. I can also compare two databases and migrate changes.

- Paul
- Database performance looks fine, it must be the Network!