SQL server export

POB · 21 Jan 2008 at 19:31

Hi,

I've developed an app that uses an SQL server database.

What is the best way to take the database and data and prepare it for distribution, making it easy for the end user to get a install of it.

voodooflux · 21 Jan 2008 at 20:12

What's your app written in (C#, VB.NET, Java, etc.) and what installation system are you planning to use for it (Windows Installer, InstallShield, Inno Setup, etc)?

POB · 21 Jan 2008 at 20:39

VB.NET with Inno Setup,

Thanks

voodooflux · 21 Jan 2008 at 20:42

Do you assume that the target machine already has SQL Server installed?

POB · 21 Jan 2008 at 20:44

Yes they will have it installed. I'm not concerned if the user has to manualy install the database.

I did find the backup system in SQL server could this work?

voodooflux · 21 Jan 2008 at 21:00

Been a while since I used Inno Setup, but the scripting language supports COM Automation so you should be able to invoke ADO/SMO to create a database instance, and then either populate the database from a backup, or create your schema and data from SQL scripts as part of your installation package.

Manlove is my forte · 22 Jan 2008 at 13:25

voodooflux said:
create your schema and data from SQL scripts as part of your installation package.

this is what I would do.