Solved

compare 2 dbs on one server

Posted on 2014-03-08
3
166 Views
Last Modified: 2014-03-10
we have almost identical 2 databases on a server. but small changes here and there.. is there any in-built ms tool that can help us without extra downloads..

i checked visual studio version.. it says 2010 shell and SS is 2008R2. what can you suggest?
0
Comment
Question by:25112
3 Comments
 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 125 total points
ID: 39915267
You should re-consider.  Your best option is Red-Gate's SQL Compare.
0
 
LVL 7

Assisted Solution

by:Sivaraj E
Sivaraj E earned 250 total points
ID: 39915384
0
 
LVL 35

Accepted Solution

by:
David Todd earned 125 total points
ID: 39916717
Hi,

Check out
http://dbcomparer.com/

Which is free. I came across this in the last week.

Regards
  David
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now