Stack Overflow
Stack Overflow

Questions tagged [sqlcompare]

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

44 questions
12
votes
2 answers

Getting error "commandtext property has not been initialized" when sql compare of Red Gate

When I compare the 2 databases with the Red Gate's SQL compare then getting below error. "ExecuteReader: CommandText property has not been initialized" I am using the SQL server 2012 express and Red Gate's SQL Compare 8 Is there any…
Tushar Maru
  • 3,347
  • 10
  • 34
  • 53
9
votes
7 answers

SQL Compare-Like tool for Oracle?

We're a .NET team which uses the Oracle DB for a lot of reasons that I won't get into. But deployment has been a bitch. We are manually keeping track of all the changes to the schema in each version, by keeping a record of all the scripts that we…
Doron Yaacoby
  • 9,412
  • 8
  • 48
  • 59
8
votes
12 answers

T-SQL - Is there a (free) way to compare data in two tables?

I have table a and table b. (SQL Server 2008) Both tables have the exact same schema. For the purposes of this question, consider table a = my local dev table, table b = the live table. I need to create a SQL script (containing UPDATE/DELETE/INSERT…
RPM1984
  • 72,246
  • 58
  • 225
  • 350
8
votes
4 answers

Red Gate SQL Compare vs. VS2010 Ultimate

I used to use SQL2000 and Red Gate SQL Compare 3.2 and I was a happy camper. I wouldn't worry about tracking the changes that I make to the dev database until all the coding was done and I needed to compile a list of scripts to bring the prod db in…
Chad
  • 23,658
  • 51
  • 191
  • 321
5
votes
8 answers

How to execute a 3GB SQL file (Microsoft SQL Server)?

I have a big SQL file that does not fit into memory and needs to be executed against Microsoft SQL Server 2008. It seems that the sqlcmd.exe tool always loads it into memory first which is impossible in this case. Any ideas? Unfortunately, I can't…
tobi
4
votes
5 answers

SQL Server Collation Conflict

Transferring data from one SQL server to another but when Schema is compared and syncronised the following error is received. We are using redgate SQL compare to complete. Cannot resolve collation conflict for equal to operation Base SQL server is…
steven
4
votes
4 answers

Error while comparing schemas of Database Project

It was working fine earlier, when I was comparing schema of a database project in Visual studio 2012 with a remote database deployed on a network server, but I am unable to troubleshoot why it is failing now. It works fine when I compare the schema…
Nexus23
  • 6,195
  • 9
  • 50
  • 67
3
votes
1 answer

Automatically create database compare scripts and execute

I have a situation where I have to compare my database version (schema) with all my clients (possibly different versions) and deploy necessary changes to make all versions alike. I'm looking for a way that automatically compares my database schema…
Harshit Gindra
  • 355
  • 3
  • 7
3
votes
2 answers

SQLCompare generate only diff script

Is it possible to generate only diff script using SQLCompare from Red Gate SQl Compare? In our database sync scenario we will use SQLCompare to generate diff script and will use Tarantino for applying scripts. I've played a little with sqlcompare…
isuruceanu
  • 1,157
  • 5
  • 23
3
votes
5 answers

SQL Server, execute batch T-SQL script on multiple databases

Our SQL Server 2000 instance hosts several databases which are all similar, one for each of our client. When comes the time to update them all, we use Red Gate SQL Compare to generate a migration script between the development database and a copy of…
MaxiWheat
  • 6,133
  • 6
  • 47
  • 76
2
votes
0 answers

VS SQL Schema Compare - sometimes missing schema on create [dbo].[xxxxxx]

I am using VS 2019 and comparing 2 databases using Schema Compare. Most of the time it finds the differences just fine and replicates them across. However, on some Stored Procedures it highlights a difference because of a schema name missing. e.g.…
Rowie
  • 243
  • 5
  • 17
2
votes
0 answers

Is there a faster way to run SQL Compare through powershell?

We currently use a house written PS script to compare developers' local SQL databases with live databases to generate deployment scripts. We use Redgate SQL Compare through powershell, typically calling it as such (where $SQLComparepath is the file…
Ben Adams
  • 129
  • 1
  • 2
  • 11
2
votes
1 answer

How to detect TFS database CLR assembly file while comparing Scripts folder from TFS to Database in SQL Compare

I am trying to create a database from my TFS project using SQL Compare. Currently we compare our Database project to a CI database using the Compare tool in Visual Studio however, I have been asked to make this eventually run as a build step as part…
JukeSpeets
  • 561
  • 5
  • 7
2
votes
1 answer

RedGate SQL Comparison SDK API Licensing Issue

First of all Sorry all that I have to write the lengthy question, But it is necessary to write these things to explain my problem better. We have an installer to install our application. I want to upgrade the database through installer. So, I have…
Mehul Vaghela
  • 478
  • 4
  • 20
2
votes
1 answer

Ignore DEFAULT with Sql Compare

I recently downloaded a free trial of RedGate's SQL Compare software. I need to prove it is a useful tool to my company so we can get some liscenses, but also want to get a couple DB schemas in sync. I am trying to do a schema comparison on 2…
Cole9350
  • 5,444
  • 2
  • 34
  • 50
1
2 3