SQL Server distribution

[Tom Archer]

Is there a way to package and deploy only the engine and any runtime support for a SQL Server database? If not and I have to tell the user that SQL Server is required, what is the easiest way to install my application's schema and data into an existing SQL Server database? In previous situations, I've exported the data and used the bcp command-line app to import the data. Is that the best way or is there an alternative? Cheers, Tom Archer - Archer Consulting Group
"So look up ahead at times to come, despair is not for us. We have a world and more to see, while this remains behind." - James N. Rowe

[oykica]

If you are referring to MSDE you can include the MSDE Merge Module in your Windows Installer. Check out this link for more information. http://www.sqljunkies.com/Article/484612DD-0416-42C8-9695-9572CA762ED6.scuk There a many different approaches to creating databases and uploading data. This SQL Server Magazine article may point you in the right direction. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag01/html/scriptingacustomdatabaseinstallation.asp