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 |
|
dkekesi
Starting Member
38 Posts |
 Posted - 2011-08-08 : 06:26:22
|
| Hi All,This is a little off topic in here, but I was not sure if this or the Administration forum is this was the appropriate place to ask.I am not looking for a specific solution but rather guides and RTFM to get me started.I am developing an application that hosts setup and run-time data in MS SQL 2008 R2. The application is working OK as installed but sooner or later some changes are made to the system. This means new columns/tables/SPs/etc. are being introduced as well as modified, maybe deleted. This will - obviously - affect existing data within tables.I must provide a mechanism that can capture the state of two databases and compute a difference between them. Are there any software on the market for automating this task? I am open to any suggestions be them free or sold for fee.Also I need to convert existing data so that the new structure can accommodate it. I know that there's no automated solution here as I need to program the rules of modifying, inserting, deleting, etc. existing data. But are there any tools on the market that support this kind of data migration process?Please note again, that I am not looking for someone who solves my problem for free. I am merely looking for a means to get started.Thank you for your help in advance.Best regards,DanielBest Regards,Daniel |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-08-08 : 06:54:00
|
| Redgate's SQLCompare and SQLDataCompare (for structure and data comparisons)--Gail ShawSQL Server MVP |
 |
|
|
dkekesi
Starting Member
38 Posts |
Posted - 2011-08-08 : 13:55:52
|
| Hi Gail,Tanks for the response. Do you have experience with these products? They sound too good to be true.Best Regards,Daniel |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-08-08 : 14:26:10
|
| Yes. Use em, love em.They're just comparison/sync tools. Find differences, sync differences. The data manipulation into a different structure you're probably going to have to hand-script.--Gail ShawSQL Server MVP |
|
|
|
dkekesi
Starting Member
38 Posts |
Posted - 2011-08-09 : 10:12:49
|
| Thanks for the feedback.Best Regards,Daniel |
|
|
|
|
|
|
|
|
OFF: guide to structural database upgrades