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 |
|
beetle
Starting Member
1 Post |
 Posted - 2002-10-04 : 10:08:48
|
| Pardonmy ignorance, as I've never had to do this before...I'm working on a database/application at work & home... [including changes to the database/schema/etc]What is the best/preferred way of updating each database [e.g. - from hometo work, work to home].1. Do I have to unattach/copy/attach ?2. Can I generate SQL scripts/statements that contain only changes to adatabase?I currently use #1, since it encompasses all [relevant] changes, etc.If I had better than a lousy dial-up at home, I'd simply connect to mynetwork and work the server copy of the database, but, alas...So this is very time consuming and irritating;1. backup [or unattach and copy]2. copy from media to local [home] drive3. attachThen when changes are done at home, to bring to work...1. backup [or unattach and copy]2. copy from media to net [work] drive3. attachIsn't there an easier way?Pardon my ignorance and Thanks in Advance!sysadmin [at] huffman-wright [dot] comBeetleX |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-10-04 : 10:30:54
|
| If you have a proper source control / versioning protocol established, you could use that to generate a script of the changes. Otherwise, backup - copy - restore is you best bet ..Jay White{0} |
 |
|
|
|
|
|
Two Locations