Stack Overflow
Stack Overflow

Questions tagged [sqlcompare]

SQL Compare is a database comparison and synchronization tool created by Red Gate.

44 questions
2
votes
2 answers

Will Problems Arise from Using SQL2008 to Interact w/ a SQL2005 DB on another machine?

I have SQL2008 installed on my local machine and need to view/alter/select rows and tables from a DB on a remote server running SQL 2005. Will I have any problems doing this. I have seen some people talk about setting compatibility for certain…
P John
1
vote
1 answer

SQL Server - SQL Compare - Automatic identification and replacement of differing database names?

I have two development databases locally Alpha Beta_Dev I have two production databases remotely Alpha Beta I use SQL Compare to sync the schema of the two Alpha databases. Sometimes, stored procedures in the Development version of Database…
Brian Webster
  • 30,033
  • 48
  • 152
  • 225
1
vote
0 answers

How to exclude database objects that include a certain Extended Property using SQL Compare 12?

I'm using SQL Compare to generate a script file to deploy to a production environment, but I can't get the Include or Exclude command line options to work with extended properties. Here is the commands I've tried so far. Let me try to only include…
arjabbar
  • 6,044
  • 4
  • 30
  • 46
1
vote
2 answers

Database Schema Validation - deployable/compilable

Looking for a tool that will allow building database schema validation that can be compiled into a standalong tool or as a module to be used in another application. The scenario is - a client/server application that is sold to customers, and…
Brady Moritz
  • 8,624
  • 8
  • 66
  • 100
1
vote
1 answer

SQL Compare GUI works, but command line gives problems

I recently purchased SQL compare 7.1 pro for the command line capabilities. We have been using the GUI version with no problems for some time now. I am trying to exclude items from the sync, however its not working. I am using the .scp file created…
Seth Valdetero
  • 11
  • 1
1
vote
1 answer

RedGate Migrations V2 Beta keep getting Invalid Object Name [TableName]

I am currently evaluating the use of RedGate SQL Source Control and SQLCompare for our Continuous Integration initiative. Starting out everything went very smoothly, it was easy to Add/Drop tables, Add nullable columns, drop columns, and so on…
bwalk2895
  • 504
  • 5
  • 11
1
vote
2 answers

FOSS version of SQLCompare or something similar?

Actually, free is good enough, it doesn't have to be open source :) I'm currently using the Schema Compare utility of VS2008, but it doesn't have a command line interface and has some other weaknesses as well. I'm wondering what free tools others…
Scott Klarenbach
  • 37,171
  • 15
  • 62
  • 91
1
vote
1 answer

Redgate SqlCompare filter not being used, causing issues

I've a couple of saved projects that I'm using from the command line to compare a database with TFS. One of my databases has a large number of asp.net related tables which all include "aspnet" in the table name, and I'm trying to filter these out.…
Fetchez la vache
  • 4,940
  • 4
  • 36
  • 55
1
vote
2 answers

redgate sql compare results differ using gui to command line

Using SQL Compare 10, I've created an .scp file which compares a local database (on the local build server) with what's in Source control (TFS via redgate SQL Source Control) Using the GUI a number of differences are listed. When running the .scp…
Fetchez la vache
  • 4,940
  • 4
  • 36
  • 55
1
vote
0 answers

How do I compare multiple rows and get the min of date in a new column?

COMPANY PROD ID DATE NAME REQD_DATE XYZ 12345 AAA111 7/1/2011 PETER XYZ 12345 PPP222 7/1/2002 JOHN MNS 67890 ZZZ999 9/1/2005 STEVE MNS 67890 DDD555 9/1/2012 MARTIN With reference to this…
user1747543
  • 11
  • 1
0
votes
1 answer

Redgate SQLCOmpare 6 Command Line => Return Code is "0" even DB's are identical

We have a NANT scripts which are using for packaging automation. We also comparing previous DB and current DB if any structural and Data changes with SQLCompare command line tool. Even I compare same database, I can't get exit code "63" which means…
Ali Bulut
  • 1
0
votes
1 answer

Compare two tables on two sql servers

i wanted to compare and identify certain [transaction ids] that exist in one table which is located in server 1 but does not exist in a similar transformed table on a different server (server 2). These two tables were supposed to be the same but we…
Yonatan Mitiku
  • 1
  • 2
0
votes
2 answers

TSQL - comparing grouped values within a table

I need to compare grouped data to look for shifts in a calculated value. The output of my current SQL looks something like this... Grp_ID_1 / Metric / State / Value A Metric1 OH 50 B Metric1 OH 65 A Metric1 CA 20 B Metric1 CA 35 In the…
Mike
  • 85
  • 8
0
votes
0 answers

Missing Dependencies and Foreign Key Constraint - SQLCompare Red gate

We use SQL Compare 11.6.11.2463 to move our database changes to different environments. When we doing that we notices that Table definitions were changes and Foreign Key Constraint was altered where the data in the table was not correct. I have a…
user1087769
  • 11
  • 5
0
votes
1 answer

Entity Framework detects model modification although db is updated with SQL Compare

I'm using Red Gate SQL Compare to upgrade my database without losing data. I also use ASP.NET MVC with Entity Framework and SQL Server. Problem is that Visual Studio still detects model modification although I've already updated the database with…
Prince Gnakou
  • 87
  • 1
  • 3
  • 12
1
2
3