Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rowter
Yak Posting Veteran
76 Posts |
 Posted - 2009-08-17 : 01:53:10
|
| HiI work on a winforms application which has a sql server 2005 database.I need to package and deploy my database on the client server.what are the different ways of doing it?Thanks in Advance |
|
|
EugeneLim11
Posting Yak Master
167 Posts |
Posted - 2009-08-17 : 05:02:45
|
| 1. Create a backup and give the backup to your client (not recommended as it will also backup your data).2. Save your scripts as a long sql script that your clients' DBA can run (recommended) - it is preferred way by bigger companies who have their own DBAs.. 3. Code it to execute a SQL files when running for first time (preferred for clients who don't have DBAs... or not technically inclined) - the code will check the database exists and if not , create it...I could think of a lot of other ways, but 2 and 3 are the favoured ways by people who have DBA(s) and people who have no DBAs (accordingly to my limited experience). (DBAs = Database Administrators). It keeps things simple for both groups of people.check out my blog at http://www.aquariumlore.blogspot.com |
 |
|
|
rowter
Yak Posting Veteran
76 Posts |
Posted - 2009-08-17 : 10:46:51
|
| Thanks.I am looking for 2nd method. I heard about it and that is the way my company wants it done.I need some articles describing the process of how to do it.Thanks a Lot |
|
|
|
|
|
|
database package and deployment