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 |
|
laurel
Starting Member
1 Post |
 Posted - 2003-12-21 : 11:54:13
|
| We release a version of our product quarterly -- some schema changes in each version. With this rapid release, we have to maintain mutiple migration paths -- currently maintained manually. Are there tools out there that would allow one to simplify this process of migrations? I imagine that that this tool could:1. Compare schema diffs and generate scripts2. Intelligently could make use of RI (etc.) so that data is loaded in the proper order3. Allow for merging of data with historical data so that new ID's are generated -- still maintaing RI.4. etc.I know we aren't the first to encounter this. This is rapidly becoming an FTE and is cost prohibiitive. Any advice would be most appreciated.Laurel |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-12-21 : 18:29:32
|
| HiYes, this product http://www.ssw.com.au/ssw/SQLDeploy/ will do thatIf you make sure your developers script all their changes this tool will keep a log of what scripts have been deployed against which databases.Damian |
 |
|
|
|
|
|
migrations\transformations from SQL to SQL