Stack Overflow
Stack Overflow

Questions tagged [schema-compare]

Tooling to compare a database-schema between databases, a live-database and a backup, or a database and a saved schema-definition.

121 questions
1
vote
1 answer

SSDT - Schema compare drops old sprocs, publish does not

I'm using database projects in Visual Studio 2015. I've noticed that if I remove a sproc from the project and then generate a publish script there is nothing in the script that will dump the old sproc. However, if I remove a sproc and use schema…
Wylice
  • 73
  • 1
  • 4
1
vote
1 answer

How can I reference another DB from a VS DB project?

We have several databases, say DB1, DB2, DB3 etc. They have to have identical code base, so we use a DB project in Visual Studio 2012 and generate a SQL script for deployment based on comparison between the project and UAT/Prod DB1. Then this script…
ajeh
  • 2,652
  • 2
  • 34
  • 65
1
vote
0 answers

Schema Compare tool in Visual Studio 2013 ASCII characters

I am comparing my project with our development database SQL Server and found a bug in the Schema Comparison tool. I found out that any ASCII character over 127 will display as a black diamond question mark, meaning the character is not recognized. …
Robert Mattson
  • 21
  • 3
1
vote
0 answers

Database schema compare options in Visual Studio 2013 - Abort Update Target

So I was comparing databases on visual studio schema compare. Then I have pressed the update target button and it proceeded to updating the schema. Now I actually get a 'The reverse engineering operation cannot continue because you do not have view…
Philips
  • 11
  • 1
1
vote
0 answers

Why does my SQL Server Schema Compare get very slow?

We have a MS sqlproject where a database project references multiple vendor databases. In other projects, schema compare is very fast, but in this project, schema compare has gotten as slow as 20 minutes. That's unuseable. What could be causing…
MattK
  • 1,521
  • 1
  • 12
  • 25
1
vote
1 answer

ssdt project in visual studio 2013 - Deploy alterscript for not empty Tables

I hoop you can Help me. I use the Skriptgeneration in the Schemacomparetool of Visual Studio 2013 SDDT Project. My Problem is I need to Update a Table that's not empty. The Schemacompartool make this: /* The type for column Bundesland in table…
Steffen Kämmerer
  • 87
  • 5
1
vote
1 answer

Is it possible to run Visual Studio Database Edition schema migrations from the command line?

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…
Damian Powell
  • 8,655
  • 7
  • 48
  • 58
1
vote
1 answer

SSDT schema compare - ignore system service brokers (VS 2013)

I have a database project in my solution and a database imported from windows azure via SSMS "Import data-tier app..." option. When using schema compare, the comparison shows system "service brokers" (message types, queues, etc.) in the delete…
Santhos
  • 3,348
  • 5
  • 30
  • 48
1
vote
0 answers

Make TFS SchemaCompare script use a predefined SQLCmd variable?

We have 3 different SchemaCompare files we run manually (saved from the built-in feature in TFS). These saved files contain the Source and Destination databases to compare against. One is to compare our DEV environment to TFS and another for what's…
Gabe
  • 5,113
  • 11
  • 55
  • 88
1
vote
2 answers

Visual Studio SSDT Schema Compare - limited number of items in the MRU connection list?

When using Schema compare -> Select target -> Choose database it seems like the list of recently used database connections is limited to show five entries. When adding 'New connection' an (apparently) random entry from the list is replaced with the…
C. Bernth
  • 28
  • 3
1
vote
1 answer

SSDT Schema Compare Update Removes schema from objects

When using the Schema Compare tool with SSDT in Visual Studio 2012 to update a database project with changes made to schema objects on a local database, the schema is 'lost' from the object declaration. I am connected to my local sql server instance…
Jason
  • 3,599
  • 10
  • 37
  • 52
1
vote
1 answer

Schema Comparison technique in Java

I am working on a web Application using Spring, Hibernate and JPA. In my application, data has to be processed in Source database and encrypted data has to be copied in Target database which is done by Masking Engine. If the application is created…
yateen
  • 85
  • 1
  • 7
1
vote
1 answer

How to limit post deployment script to run only once in Visual Studio database project

We have a post deployment script in our visual studio database project. It populates lookup tables with data. The problem is that every time we change schema and generate update script, post deployment script gets appended to the end of the…
fenix2222
  • 4,602
  • 4
  • 33
  • 56
1
vote
1 answer

Red Gate MySQL Compare showing similar objects shown in the differences group

I am doing a MySQL Red Gate schema compare and there are objects being shown in the differences group, but the compare view shows no differences. Am I missing something?
Mike Flynn
  • 22,342
  • 54
  • 182
  • 341
0
votes
0 answers

How to generate DDL script for schema differences with Python?

i`m looking for ways to generate DDL ALTER script between different versions of the same model using python. Let`s say i have two DDL scripts for different versions of the model(newer and older), i need to compare those two and then generate DDL…
bogomol
  • 1
1 2 3
…
8 9