Hi

Another alternative would be to ship a default data and log file that is
already populated. For upgrades then a similar container but you would need
to use a tool such as those produced by www.red-gate.com sqlcompare or
www.innovartis.co.uk/Home.aspx dbghost or your home grown application.

John

"Robin Tucker" <idontwanttobespammedanymore@reallyidont.com> wrote in
message news:c97t42$rmv$1$8300dec7@news.demon.co.uk...
[quoted text, click to view]

Hi there,

Getting ready for deployment and I would like to be able to run an install
script that will not just generate the schema, but fill in some of the
tables with default data. Is there a tool out there that will scan user
tables in an SQL database and generate the script required in order to
create a database with this default data?

Thanks


Robin

"Robin Tucker" <idontwanttobespammedanymore@reallyidont.com> wrote in
message news:c97t42$rmv$1$8300dec7@news.demon.co.uk...
[quoted text, click to view]

http://vyaskn.tripod.com/code.htm#inserts

If you have a lot of default data, it might be more efficient to have the
data in flat files and load it with bcp.exe or BULK INSERT.

Simon