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 |
|
karuna
Aged Yak Warrior
582 Posts |
 Posted - 2005-04-26 : 08:45:39
|
| I have two databases, One I use for sql development the other one is used by other developers. Both have same kind of tables but different stored procs, views, triggers etc.,Is there a way to compare both these database and update one of them with whatever missing from the other database?Karunakaran___________It's better to be loved and lost, than ever to be loved... |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2005-04-26 : 09:01:48
|
| For a while we were using Red Gate's SQL Bundle which has a decent compare/update tool. I'd suggest you look for something like that (google) and download a trial version. If this is something you'll have to deal with frequently, it might be worth the investment.Mike"oh, that monkey is going to pay" |
 |
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2005-04-26 : 10:11:08
|
| I have already downloaded the trial version of SQL Bundle. Since I dont have an admin access to install it I'm trying to find something else which will help. The other option is wait till t'row for the sys admin.Karunakaran___________It's better to be loved and lost, than ever to be loved... |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-04-26 : 16:14:12
|
A more manually intensive way would be to script out all of the objects, run a WinDiff or other free text-file comparison of them, build a script to make the changes, and run it. But that might take longer than waiting for the Admin to arrive. ---------------------------EmeraldCityDomains.com |
|
|
|
bakerjon
Posting Yak Master
145 Posts |
|
|
|
|
|
|
|
Comparing Databases