September 26, 2006 at 9:54 am
Hi All, SQL Server 2000
First of all, appologies if this post is in the wrong forum.
We have been developing a system using SQL server 2000 as the back-end for in house use. We would now like to sell the software to other companies but the problem we face is distributing our database. I know we can use SQL Server Express, but how do we create an install package for it then get it to setup our database complete with tables including sample data, stored procs, logins, roles, permissions etc. (I know I can script the db from enterprise manager but that won't give us the sample data which would take ages to code into the script). Can anyone point me to some software for this / useful acticles / code. Also, is it possible to automate the setup of the SQL server so that things like the authentication mode and password are pre-set.
Thanks for any advice.
CCB
September 26, 2006 at 4:09 pm
One of the suggestions may be to install Express out-of-the box and get the installation SW to copy a database file to its location and then run a couple od short SQL of VSscript scripts to attach or restore the database, create an appropriate user with password, change SA password, set the authentication mode etc.
Regards,Yelena Varsha
September 27, 2006 at 11:50 am
The only additional advice to add is to make sure you make things an MSI package using the MS tools - not that of a third party vendor. Your support staff and the support staff of your clients will thank you for that.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply