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 |
|
priyaram
Yak Posting Veteran
82 Posts |
 Posted - 2005-10-03 : 17:15:58
|
| Is there any script or .exe file that we can use for sqlserver for any upgrade of database.In our company we are querying againt an vendor supported tables into our sqlserver and they upgraded their tables now.now our table structures are also changed.so if we want to move our new table structures to production and want to map the existing data to new table structures means , how it can be done? |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-10-03 : 21:19:58
|
| there are several vendors with products that can do this. redgate has sql compare, Imceda has Change manager, apexsql has some tools also.-ec |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-10-03 : 23:49:34
|
| Bit late for you this time around, but we script all changes we make to the DEV database, so that those scripts can be used (in order) to update QA and PRODUCTION databases.In Enterprise Manager "Design Table" there is a button to "Save changes script" which will create a suitable script autoMagically!Kristen |
|
|
|
|
|
|
upgrade of database