Visual Studio 2008 Database Edition (Data Dude) has the ability to perform schema comparisons between databases and generate a script which migrates from one database to the other. Is it possible to perform this comparison and generate the migration script from the command line? If so, what are the command line tools, and are the same to...
Is it possible to ignore the schema in object names when comparing databases using Visual Studio 2010 Schema Compare? For example, I'd like [dbo].[mysproc] and [mysproc] to be considered equivalent. ...
It should be a tool to enable versioning of a database schema and efficiently updating databases with older versions of the schema: robustness, does it handle all edge cases support for data migration command line execution flexibility, can some data be compared as well In the answers a breakdown on support for these points (and anyt...
Hello, I am using Visual Studio 2010's database functionality to compare database schemas. I am comparing database#1 and database#2. I would like to compare only only objects within the same security schema within my databases (dbo, myschemaname, etc.) rather than comparing all objects within that database but I cannot figure out how to ...
As the title says, I am using a full version of VS2010 Ultimate and everytime I try to do a schema comparison VS crashes. The debug error is: Unhandled exception at 0x75549617 in devenv.exe: 0xE0434352: 0xe0434352. Anyone had this issue and can you help? thanks ...
I'm trying to use the Sql100DatabaseSchemaProvider to generate a schema comparison and update script in code at runtime. It's not the same task really, but I'm using this: http://blogs.msdn.com/b/bahill/archive/2010/05/04/leveraging-the-visual-studio-2010-database-deployment-api.aspx as a working reference... So far I've got to the po...