Best way to deploy schema

[tellytubbie]

Hi
With msde whats the best way to deploy a database to new sites - I was hoping that I could use the tsql back up statment to dump the schema out as a series of ddl statements (or otherwise) ala postgres - but it doesn't seem to work like that.
Whats normally happens in the real world re this?
tia
TT

 

[nigelrivett]

You can use dmo to create a file with the statements I think.
See

http://www.nigelrivett.com

DMO

I would advise kepping all object scripts in sourcesafe anyway to keep a history of changes.


======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.