Compare 2 separate sql databases

Posted on 2012-09-13
Last Modified: 2012-09-13
Hi Experts,

A long time ago a developer added some columns to a large # of tables ...

The Problem is that this data has become corrupt...

I have a standard set of these tables and I need to identify what the differences are at the Column level..

Can anyone help me with this..

This is super important
Question by:Mikeyman_01
    LVL 75

    Accepted Solution

    down load the trial versions of sql compare softwares, that should work for 14 days  sql compare or DataCompare
    apex sql tools
    LVL 68

    Expert Comment

    Or try:

    tablediff.exe  [from MS themselves]

    It can be tricky to get working the first time, especially if you're not familiar with command-line interfaces, but it works well enough once you get the hang of it.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    759 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

    12 Experts available now in Live!

    Get 1:1 Help Now