Generate Tables and Sproc with vb.net

[Stan Sainte-Rose]

Hi,
I need to generate my sql tables and stored procedures.

I have made a .sql file where I have all my tables and stored procedures
with Sql Server Enterprise Manager
So the question is how to generate all of them from a vb.net ?
The best would be to read the file from the disk and create the different
tables and sproc.
Thanks for your help

Stan

 

[Miha Markic]

Hi Stan,

I can recommend you the free tool Code Smith which does this and a lot more.
http://www.ericjsmith.net/codesmith/