May 12, 2010 at 8:04 am
Hi there,
I have recently been working on a new version of some software that my company produces. During this, we setup a DEV environment for me to do with as I will. Basically a complete copy of the databases, procedures, tables etc, that I could setup as required by the new version to fill the new requirements.
Alot has changed. What I need is a script to loop over the whole database and produce either a list of the differences, or scripts to alter the live version to be equal to the dev version.
I've read over "Poor Man's Table Difference" and didn't understand enough of it to be able to edit it. So, I come to you for help 🙂
I'm not going to be capable of doing it, so if no-one has any idea I'll be manually messing with the table structures, etc, which will take me some time. Hope someone has some idea :hehe:
May 12, 2010 at 8:07 am
have a look at redgates SQL compare, it will do all this with ease. I think there is a trial version on their website
May 12, 2010 at 8:07 am
look at this tool
May 12, 2010 at 8:27 am
The tool shows me the differences. . . but without creating the "alter" scripts it's not much better than my manual option. I've hit 145 differences between 2, 83 between another 2, then under 10 for the last 4 dbs. That's not including the new tables or roles. :crying:
May 12, 2010 at 8:31 am
it creates the scripts for you, just click on the Synchornization Wizard button you can save the scripts or apply them through the tool
May 12, 2010 at 8:41 am
Thankyou, that's superb! :w00t:
May 12, 2010 at 8:44 am
No worries,
its an excellent product, also you may want to have a look at their data-compare tool for promoting the data from dev to production
May 12, 2010 at 8:46 am
I work for Red Gate, and this tool has many rave reviews over the years. There are other products as well, but you are better off buying a product for a couple hundred $$$. You can't write one in your time that will work as well.
May 12, 2010 at 8:51 am
Once I've gone over the scripts created, I'll be speaking to the boss about how much time it saved. . . fairly sure that the time saved equals far more than the cost of the software and that's for one use. We'll see if I can argue him into buying.
For now, the 14 day trial seems to have done exactly what I want. . . but I do now have a few thousand lines of sql to go over. Always fun :hehe:
May 12, 2010 at 8:57 am
If you want time savings. Pick 4 tables, 2 small, 2 large ( in terms of changes) and compare the time to find the differences or check with your own scripts and with SQL Compare. I'm sure you'll have some good metrics.
May 12, 2010 at 9:10 am
Just a follow-up on this. My favorite software to do this is also Red Gate SQL Compare.
However, you should know that there are others out there, Apex, Idera, Atlantis Interactive... They all do pretty much the same thing, but there are differences and you might find one that works better for you & your circumstances.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 12, 2010 at 10:06 am
I'll just show the timesheets off. . . took me two days to work through all of the changes last time and that was a smaller project than this one.
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply