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 - 2010-01-22 : 14:22:24
|
| Hi,One Question on sql server. I have to deploy the application on client site.so, now i have to create the database.I have to create the tables.I have to prepopulate 5-6 tables. Which is the best way to do it? Thanks |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-22 : 14:26:32
|
| We keep a "Shipping Database" that is oven-ready for new deployments.That will be no help if you have to make a one-off deployment.You could script the database, make a new database, run the script, and then copy across the starter-data you need ...... or you could selectively delete the data until your DEV database is empty, except for the starter-data you need to retain. |
 |
|
|
|
|
|
Create database for deployment