Is anybody usingAPexSQL Data diff 2008 and ApexSQL diff 2010

Posted on 2011-04-20
Medium Priority
Last Modified: 2012-05-11
i need help in comparing the two databases
Question by:Cha1tu
LVL 28

Accepted Solution

Ryan McCauley earned 1000 total points
ID: 35439282
What, specifically, do you need help with when comparing the databases - just a walk-through of how to do it? If you need some general assistance, the demo video on their site shows a walk-through of the product (it's a marketing video, so it's under the guise of "how easy it is to use", bu the effect is the same - they show you how to do a basic comparison), and that video can be found here:


If you have some more specific questions, please elaborate and we can do our best to help you.

I've used this tool before, and though I generally prefer RedGate's tool for the same purpose, they're remarkably similar in functionality and interface.

Assisted Solution

radcaesar earned 1000 total points
ID: 35468962
Using ApexSQL is your requirement?

To compare two database tables and to sync that, I always use "tablediff.exe", An inbuilt tool by sql server.

It compate two tables from two different databases and writes the Insert/Update and Delete sql queries.

When you execute those SQLs, thats it....... Your database will be in SYNC.

An elegant tool from MS SQL Server.

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
The title says it all. Writing any type of PHP Application or API code that provides high throughput, while under a heavy load, seems to be an arcane art form (Black Magic). This article aims to provide some general guidelines for producing this typ…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

850 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