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 |
|
verinow_mark
Starting Member
2 Posts |
 Posted - 2006-05-04 : 17:17:28
|
| Hi,We are using SQL-Server (2005) for the first time and have developed an app that uses 2 dozen tables and a bunch of SP, triggers, etc.How do we get our entities to our client site without a lot of copying and pasting? How about the data we want to upload for lookup tables - how would we get the data there?Moreover, how do we sync stored procedures with the live database as we make changes during development?Thanks,Mark |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-05-04 : 17:47:33
|
| Create a blank database on your server. Copy over all objects (minus the data) that you want in it, including indexes and constraints. Add all of your static data. Take a backup of this database. Send the backup to the client's server. Restore the backup on the client's server. Instead of backup/restore, you can also use detach/attach method.Any changes made to your server should be scripted. These scripts can then be used to update the client's server. I haven't used Management Studio very much yet, but I'm sure it has a generate SQL script utility just like Enterprise Manager. In that utility/wizard, you can generate the script for your tables, views, sps, udfs, etc... Your update script should not include tables as it generates a drop/create, which means you'd lose data. So be sure to select the options that you want scripted.Tara Kizeraka tduggan |
 |
|
|
|
|
|
|
|
Deploying to remote database