Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jsmith
Starting Member
24 Posts |
 Posted - 2002-07-14 : 09:07:33
|
| Previously all my company's sql server databases have been created using a command line based script, using isql.Does anyone know of any more customer friendly methods? I have thought of using the COM interface for DTS, and trying to integrate that with a product such as Install Shield.Any suggestions/help would be appreciated. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-07-14 : 09:35:14
|
| Using a script is a good way - whether or not run by isql (or osql now). See the article on release procedures on www.nigelrivett.com.You could use dmo which exposes it's objects and is meant to be used for this sort of thing.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
 |
|
|
jsmith
Starting Member
24 Posts |
Posted - 2002-07-16 : 04:46:10
|
| Thanks for that Nigel.If anyone haas any experience using DMO/COM for a DTS based installation, then any advice would be greatly appreciated. |
|
|
|
|
|
|
SQL Server database creation