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

Selectively Update SQL Server Database Schema from Visual Studio 2010

I'm using the schema compare tool inside of VS 2010 to compare my Dev and Prod SQL Servers. There's a bunch of changes to the Dev that I don't want pushed to the Prod server, but there are a few that I do want pushed. Is there a way I can select…
Tyler DeWitt
  • 23,366
  • 38
  • 119
  • 196
1
vote
2 answers

SQL Schema compare - column level actions

I have a production DB and a dev DB. I'd like SOME of the Dev DB changes to be propagated to the Production DB. The production DB also has some new columns and changes due to bug fixing. I need a Scema Compare Tool that allows for acccepting/deniyng…
mfr
  • 149
  • 3
  • 11
1
vote
2 answers

DB2 SQL query to compare 2 schemas

I have been unable to find a solution in my searching for this throughout the web, most responses recommend a tool, which leads me to believe this may be very difficult with an SQL query or something, but... I have been told to write a query for our…
Clayton
  • 11
  • 1
  • 2
1
vote
0 answers

"Drop objects not in source" not honored

I'm attempting to use Schema Compare in SQL Server Data Tools to update my project from a database. I deselected "Drop objects not in source" setting but SSDT continues to drop objects that are not in the source (database). I've tried it with tables…
Shelly
  • 11
  • 1
1
vote
1 answer

Visual Studio 2019 Schema Compare trying to add procedure that already exists

I am having this issue where Schema Compare in Visual Studio 2019 has detected that we don't have an SQL Stored Procedure and want to delete it from the live database, but if you can see the attached screenshot, we do have the stored procedure in…
Aasim Shakil Pathan
  • 41
  • 1
  • 10
1
vote
2 answers

Visual Studio 2019 Schema Compare Crash

When I run the Visual Studio 2019 SQL Schema Compare tool, it correctly identifies the differences between 2 databases. Then whenever I try to "Update" or "Generate SQL" to update the schema on my target database, Visual Studio crashes. Looking…
WillC
  • 1,761
  • 17
  • 37
1
vote
0 answers

SQL Server Schema Compare displays all Tables, Views, Procedures, Functions in database

I have a .NET project. When I do a SQL Server Schema Compare between what is on a local SQL Server 2017 database to Visual Studio in the direction of Database --> Project, the compare lists all tables, views, procedures and functions that are in the…
cormacio100
  • 67
  • 8
1
vote
1 answer

Visual Studio 2019 Database Schema Compare ignores foreign key names

This is all related to SQL Server. Visual Studio 2019 Database Schema Compare ignores foreign key names (definition of the keys is the same) when comparing schema between Database Project (source) and actual database (destination). It is not just…
Joe Schmoe
  • 1,574
  • 4
  • 23
  • 48
1
vote
1 answer

Schema Compare and SqlPackage 150 case sensitivity issues

So I installed the new SqlPackage 150 (having had 140 before with no issues) and deploying the database twice (sqlpackage is a joke, this twice needs to be done on any update to see what new quirks it has when it alters untouched code), I noticed…
CodeAngry
  • 12,760
  • 3
  • 50
  • 57
1
vote
0 answers

Schema compare is not recognizing target source database objects

I recently updated from Visual Studio 2017 Enterprise to 2019 Enterprise. In my solution, I have a database project where I develop my tables, SPs, etc. and use "Schema Compare" to update my database in SQL Server. When I open schema compare,…
TSoder
  • 41
  • 1
  • 3
1
vote
2 answers

unexpected differences from Schema Compare in Visual Studio 2017

I have this weird behavior of Schema Compare in Visual Studio 2017. When comparing 2 databases, two identical tables I get difference that one of those has no PK name. If I would script out tables using SSMS I would see that indeed on one of the…
Ramūnas
  • 1,494
  • 18
  • 37
1
vote
0 answers

ssdt - Schema Compare - ignore log files

I am running schema compares from the command line. The ONE option that does NOT seem to have a toggle is log/sql files. Regardless of my setting every single toggle to OFF I STILL get the sql/log files showing up in my compare results. What do I do…
user5855178
  • 567
  • 1
  • 7
  • 17
1
vote
1 answer

Visual Studio 2015 Schema compare not displaying changes

I am trying to do a schema compare in VS 2015 to identify what changes i have made to the staging database, but it is not displaying any changes for some reason. It only displays delete and add. I know for a fact i have made changes to numerous…
Fizor
  • 1,480
  • 1
  • 16
  • 31
1
vote
1 answer

Visual Studio Professional 2015 - SQL Schema Compare & reopening .publish.sql generated scripts

Not sure if this has been an issue before or this is a new error with the latest tools update, however: I've noticed that after running a comparison between two database and clicking on the "Generate Script" that the *.publish.sql will run…
Chris_
  • 716
  • 8
  • 11
1
vote
1 answer

MSSQL Schema Compare by T SQL

I have 21 DBs on same server which are 'supposed' to have the same schema (limiting schema only to table schema as of now) but they don't. In the environment I am, I can not install any tool/applications as per the compliance rules. The only way I…
Alok Singh
  • 174
  • 3
  • 15
1 2 3
…
8 9