[Last Call] Learn how to a build a cloud-first strategyRegister Now


Compare 2 separate sql databases

Posted on 2012-09-13
Medium Priority
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

Aneesh Retnakaran earned 2000 total points
ID: 38396791
down load the trial versions of sql compare softwares, that should work for 14 days

red-gate.com  sql compare or DataCompare
apex sql tools
LVL 70

Expert Comment

by:Scott Pletcher
ID: 38396874
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.

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I have a large data set and a SSIS package. How can I load this file in multi threading?
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

830 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