December 10, 2008 at 5:46 am
Forgive me if this is the wrong forum but I was unsure where to post. If this is not the right forum, please let me know where to post.
I have a Winforms (VS 2008, C#) and SQL Server 2005 Express db (approx 25 tables and 120 sp's).
I have created an installer in Visual Stuido but unsure how to package the db to install on another client.
The way I have been doing it now is to
1 - shut down SQL Server on dev server (Config manager)
2 - copy db and log file
3 - restart SQL Server on the dev server (Config manager)
4 - download and install SQL Server 2005 express and Management studio on client from web
5 - shut down SQL Server on client (Config manager)
6 - copy db and log file to client, attach to SQL Server 2005 express via Management studio
7 - start SQL Server on client (Config manager)
8 - install Winforms application
(6 & 7) could be reversed but you get the idea
There must be a way I can package it all up and not have to keep shutting down the SQL Server OR manually installing SQL Server for each client. I have searched many forums and have had no luck.
Any help is greatly appreciated,
Mark
December 14, 2008 at 8:33 am
No one has ever done this???? Any suggestions at all?
Thanks
Mark
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply