January 28, 2002 at 7:35 am
Hi
I know that there are a lot of tools to compare databases etc..
But cannot use these(don't ask)
I need to know how to run some scripts that will check that certain stored procs are teh same between databases
And also that some key application tables have the same structure and data.
January 28, 2002 at 9:36 am
One posibility would be to generate scripts and save them as text files. The files could be compared in SourceSafe or TextPad which will both list the differences.
Paul Ibison
Paul Ibison
Paul.Ibison@replicationanswers.com
January 28, 2002 at 9:52 am
The SourceSafe method is how we compare differences. And unless I'm mistaken, I believe that is how SQL Compare works.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
January 28, 2002 at 10:22 am
February 2, 2002 at 7:31 pm
SQL Compare. License for single user is very reasonable. Not hard to justify the ROI.
Andy
February 5, 2002 at 1:51 pm
You may also want to check some of the download sites for freeware as far as comparing two scripted files all you have to do is find a freeware editor that will compare 2 text files.
February 5, 2002 at 2:25 pm
Definitely you can find tools like WinDiff to compare the files - the fun is in generating a script that will correct the differences!
Andy
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply