May 31, 2005 at 12:01 am
Hello
I have a .NET web application that uses an MS SQL database. The tables contain a significant amount of default data that needs to be distributed with the application. I'm only a newbie to this part of MS SQL and am unsure how to proceed.
I want to be able to distribute a single package that the users can run / execute. Is there a method or tool that will allow me to do that?
Regards
James
May 31, 2005 at 12:38 am
I guess it depends on how you package your ASP.NET application. A common way to handle this is to have a setup page that the user should navigate to when setup of the site is complete. From there you execute the T-SQL that sets up your default data.
But if you are using some kind of install app for distributing your web application then you could integrate the database setup from there of course.
May 31, 2005 at 9:11 am
Get SQLPackager from RedGate. It's cheap, easy, and will make this bulletproof. It's like US$500, which is probably relatively few hours of your time, not to mention it's been tested, so there will be fewer bugs. Plus if things change, it can repackage easily.
Review: http://www.sqlservercentral.com/columnists/mvermeulen/reviewsqlpackager.asp
May 31, 2005 at 4:59 pm
Thanks for that!
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply