Stack Overflow
Stack Overflow

Questions tagged [red-gate-data-compare]

With SQL Data Compare, you can compare and deploy the data in two Microsoft SQL Server databases. You can also compare a backup with a database, a scripts folder, or another backup.

7 questions
1
vote
1 answer

Can Redgate SQL Data Compare be Automated?

I am using Redgate Version 10. I want to have the source control in place for one of the database tables. So, whenever I modify the data in the source control and run the automated script, It should update the database with the source control…
turbo88
  • 423
  • 2
  • 8
  • 23
1
vote
1 answer

Redgate SQL Compare - How to ignore differences of Column order?

I am using RedGate SQL Compare 11.6 to compare two SQLServer 2016 databases. The problem is, the comparison result includes tables that have same columns but in different order. I would like to exclude this. Is there a way to do these? RedGate's…
Devasayal
  • 40
  • 8
0
votes
1 answer

Postgresql Schema and Data Compare

Is it possible to compare postgresql database in Redgate SQL Compare tool. or Any other recommend tool for postgresql database compare tool.
Vinoth
  • 53
  • 2
  • 7
0
votes
0 answers

RedGate loading oracle tables metadata fails

I’m using Redgate Data Compare for Oracle 5. I’ve (successfully) created Source and Target connections (both Oracle 11g), defined schema names on both side, then switched to "Tables & Views" tab. There was Initializing process popped-up, like…
Ikacho
  • 75
  • 1
  • 1
  • 6
0
votes
1 answer

Redgate failing to compare schema between different versions of SQL Server

I am trying to compare the data and schema using SQL Compare and SQL Data Compare (version 10.2). The databases I am working with are in versions 2014 and 2016 of SQL Server. I am getting this error message. Any idea why this is happening - could…
t_plusplus
  • 4,079
  • 5
  • 45
  • 60
0
votes
1 answer

Using Data compare to copy one database over another

Ive used the Data Comare tool to update schema between the same DB's on different servers, but what If so many things have changed (including data), I simply want to REPLACE the target database? In the past Ive just used TSQL, taken a backup then…
BitShift
  • 123
  • 2
  • 14
0
votes
1 answer

Setting Default value when Object mapping in Red-Gate Data Compare

I am using Red-Gate Data Compare to synchronize two databases, lets call them DBSource and DBDestination. DBDestination has a table, TableA which has a field which has a not null constraint. TableA within DBSource has the same structure, apart…
Christian Phillips
  • 18,399
  • 8
  • 53
  • 82