- Redgate Data Compare
- Redgate Compare Stored Procedures
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?
In SQL Compare 10.2 and later, _ (underscore) works as a wildcard matching any character, as it does in SQL. This means that a filter that excludes objects beginning with _ will exclude all objects. WATCH THE NEW INTRODUCTORY VIDEO TO SQL COMPARE 12 AT Redgate's Tom Austin shows you how to use SQL Compare, the industry standard tool.
RedGate's Support forum and help documents say that 'Default behavior is to ignore such differences' But it doesn't seem to work like that.
DevasayalDevasayal
1 Answer
By default it doesn't compare column order. To validate this, I set up a test this way using SQL Server 2016 & Compare 11.6:
When I ran compare against the two tables, the output was here:
If you note at the top, it says there are 24 identical objects. These two tables count as identical. However, compare does note that the column order is different. There's an option you can set 'Force Column Order' that changes this behavior. When that's enabled you would see this from the comparison:
Redgate Data Compare
It's possible that's what you're seeing. Check the options on the Compare project.
Grant FritcheyGrant Fritchey
Not the answer you're looking for? Browse other questions tagged redgatered-gate-data-compare or ask your own question.
Redgate Software makes tools for Microsoft Developers working with SQL, .NET, Oracle and Cloud. The tools are designed to optimise the deployment process for database development team. For .NET developers, Redgate tools help to optimise software performance and improving quality of software.
1
1answer
Readyroll : Getting Error While Build using VSTS : Drift analysis: These changes will NOT be applied because DriftOptionBlockDataLoss=True
Some of the scripts were migrate manually without using readyroll script. Now any new push to dev branch fails with following error : DBDB.sqlproj(0,0): Error : Drift analysis: These changes will ...
1
0answers
Not able to view the Database Diff Report in Azure Devops Build pipeline
I was able to use the Redgate Ready Roll extension in Azure Devops Build and Release Pipeline. Everything was working fine till 8th April,2019. Now, suddenly I am facing below challenges. I am not ...
1
0answers
Redgate source control - how to tell which repository of a Git repo that the Db is linked to?
My team is using redgate source control for our databases with Git. I noticed that as I was looking at the database, it wasn't obvious which source control path eg. which branch it was linked to in ...
0
1answer
Redgate Schema Compare
Our constraint names are typically left to SQL to auto generate so, when comparing databases, they always come up as a difference. I've selected 'ignore constraint and index names' but they are still ...
0
1answer
Using Oracle partition and storage options with Redgate Schema Compare fails
I'm trying to introduce new audit tables for our project. In the deployment process we use redgate's Schema Compare for Oracle (version 4.0.8.420).The table looks something like this:create table ...
0
0answers
ReadyRoll- set default target connection string at startup
I just started using ReadyRoll and created a local database with it, using production database as target. My concern is, if I have prod db selected as a target db because I just deployed something to ...
0
0answers
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. ...
0
0answers
Redgate source control when code refers to other Dbs on the same server?
Ive looked at Redgate source control before, but have since been using Visual Studio SQL projects and either SVN or Git as a backing SCM. Lately, I've ran into an issue with the compare tool (part of ...
0
1answer
VS2017 can not load sqlproj after IDE update wrong $(MSBuildExtensionsPath) value
I just update my visual studio and I am not able to open my sqlproj included into my sln.The issue is the following one : error : The imported project 'C:agentMicrosoft.Data.Tools.Msbuild...
0
0answers
Red Gate - .NET Reflector Visual Studio Extension Version 10 - Visual Studio 2017 - Need to Disable Obfuscation
I recently installed this extension. It is letting me step into the source code of dlls the source of which I own. Unfortunately I see the code I am stepping into has been obfuscated. I have not ...
0
0answers
USE executable in ants memory profiler
I want to profile my .exe of an asp.net application using ants memory profiler , but i could not get any results i tried to add a prompt commande : 1. Profile.exe /e:'C:testingSimpleApp.exe' /ll /...
0
0answers
FastMM Alike Alternatives for VisualStudio 2017?
I used FastMM (when I worked in Delphi) to find and fix memory leaks and I find it best tool I used ever for such task. It was easy to set up, lightweight, simple and to the point, and once setup, ...
2
1answer
SQL Server Backup with Free Space
Can a lot of free space in both SQL Server data and transaction files reduce performance when backing up and compressing files? Our DBA is using Red Gate SQL Backup Pro to backup and compress a ...
0
0answers
Does RG old version of the tools support all new upcoming SQL Server versions?
We would like to buy SQL Compare, but we're not sure if we are required to upgrade each time new version of the tool is out in order to use it on new SQL Server versions? We plan to move to SQL Server ...
0
1answer
Redgate Compare Stored Procedures
Redgate Extension for Visual Studio
I want to know if there is a Redgate Extension for Oracle databases in Visual Studio similar to 'ReadyRoll SQL Server Database Project' which supports SQL Server databases only ??Thank you all.
153050per page