July 18, 2003 at 11:26 pm
I wanted to know
when i distribute a .NET application to anyone......do i everytime need to install the server and create the databases and tables......can't i deploy a sql server databases and tables the same way i deply a .net application.....please clarify
July 20, 2003 at 6:20 am
To distribute the server you'd have to deal with licensing, and even then its better handled as separate installs (one for your app, standard one for SQL). Unless you're using MSDE. You make having the server installed a prerequisite, then it's up to you to either create all your objects at install time, provide an mdf that can be attached, or provided a script to create all the objects.
Looking at it as a DBA, scripts are my favorite, the user can send to me, I can review, I can run since the average user won't have permission to do so. You also have to consider what login mechanism you'll be using and provide a way to get the login set up and the user created in the database, permissions granted, etc.
I highly recommend using .MSI for distribution, rather than the "xcopy" deployment. Xcopy is fine for basic apps, but once you need to do some other install steps (as simple as creating an item on the programs menu) msi offers a much easier way to do it.
Andy
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply