Simple way to create databases from SQL script?

[dBrong]

I'm looking for the cleanest, most error free way to create databases from scripts generated by SQL 2005. I'm using vb.net 2.0

I tried taking the script and doing an .ExecuteNonQuery it didn't work. Once I removed the "GO" statements it worked like a charm.

Ideally, I'd like to execute the scripts (from VB) just as SQL generates them.

What class/method does one use in .net to execute the scripts as SQL generates them?

Thanks!

[jezemine]

If you use the ServerConnection class, you can execute scripts with GOs in them, using the ExecuteNonQuery() method.

see:

http://msdn2.microsoft.com/en-us/lib...n_members.aspx

[dBrong]

I got the SMO to work. One more thing....

When SQL generates the scripts for the tables, it includes a:

[USE AX30] <---- my 'working' database name. Which may not be the db name that the user will want (some users will have several db's with the same structure).

Do you know if there's any way to suppress the 'USE'?

Thanks!

[jezemine]

what SMO class are you calling Script() on that includes the USE statement? Table.Script()? it shouldn't include the USE as far as I know...

[dBrong]

I'll look into generating the scrpits right from smo.

Thanks again for your help.

[jezemine]

if you want, you can try out a free tool I wrote just for this purpose:

http://www.elsasoft.org/tools.htm