sqlcompare

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 from the GUI. My syntax is: SQLCompare.exe /pr:"file.scp" /v sync >> Log.txt. I have trie...

Are there any free alternatives to Red Gate's tools like SQL Compare

Any tools as useful as these? ...

How to execute 3GB SQL file (Micrsoft SQL Server)?

I have a big SQL file that does not fit into memory and that 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 cannot split the script because it is generated by Redgates excellent SQL Data Compare. the...

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 things, but this seems to only be when using new terms for SQL 2008 that don't exist in SQL 2...

Redgate's SQLCompare Schema Comparison Not Removing or Adding Objects Via Command Line

I have a saved SQLCompare project which I use to synchronize my local database with another "master" database. When I run the project via the GUI, everything works fine. However when I run it via the command line, only objects that exist on both sides get synchronized. For example, if a column is added to or removed from a table, that ch...

SQL Server, excecute 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 the current state DB of all the clients database. SQL Compare generates a script which i...

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 are using to provide command line schema comparisons/synchronizations? Thanks. ...

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 maintained through service releases. The service releases include database scripts to updated t...

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 sync with the prod. This is where SQL Compare and to some degree, SQL Data Compare, were ...

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 statements) that will update table b to be the same as table a. This script will then b...