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
4
votes
2 answers

Visual Studio 2015 Update 2 and Sql Server 2016 Schema Compare

I recently upgraded to Visual Studio 2015 Update 2 and that all went smoothly however, now when I attempt to do a Schema Compare from a data project against a Sql Server 2016 database it shows that i needs to create all objects in the database. …
Lereveme
  • 1,614
  • 2
  • 15
  • 18
4
votes
1 answer

Schema Comparison times out

On doing a Schema Comparison in Visual Studio 2013 between a Database Project and an Azure SQL Database, I keep getting the following timeout errors: Error 1 An error was received from SQL Server while attempting to reverse engineer elements of…
Dave New
  • 38,496
  • 59
  • 215
  • 394
4
votes
1 answer

How to make Visual studio schema comparison igonore database references

We are using Visual studio 2010 and our database scripts are in a database project. We have two databases DB1 and DB2. DB1 uses DB2. I created a database project for each of databases and added DB2's .dbschema file as a "Database Reference" to DB1's…
Veysel Ozdemir
  • 675
  • 7
  • 12
3
votes
3 answers

What causes "SQL01268: Msg 1834: cannot be overwritten. It is being used by database"? (in Database Project)

Full error below: Error 1 SQL01268: .Net SqlClient Data Provider: Msg 1834, Level 16, State 1, Line 1 The file 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\testdatabase.mdf' cannot be overwritten. It is being used by…
LaserBeak
  • 3,257
  • 10
  • 43
  • 73
3
votes
2 answers

Schema Compare and Update comments out unused code

I have a Visual Studio 2010 Database Project. It works great for most stuff. However one thing is very annoying. Say I have a table called dbo.MyCoolTable. If I go the the database and rename it to dbo.MyKindaCoolTable it works fine in the…
Vaccano
  • 78,325
  • 149
  • 468
  • 850
3
votes
0 answers

Visual Studio Database Project References

I’m really confused with how to use database projects in Visual Studio (2019). I’ve created a new project and imported my database into it. I then can happily edit the SQL and commit it into source control, however, when I try to deploy the items…
Matthew Mara
  • 31
  • 2
3
votes
1 answer

Transferring saved data connections between Visual Studio installations

I use the data and schema comparison tools in Visual Studio a great deal. I just finished installing VS 2010 on a new VM and realized, of course, that all the saved data connections from my previous installation are not available. Is there a way…
Jon
  • 4,925
  • 3
  • 28
  • 38
3
votes
1 answer

How to setup schema compare file so that it always ignores a specific db schema?

I have two SSDT projects targeting the same database. When I use Schema Compare feature from any of the projects, it detects the other project's objects as being non-existent and sets them for deletion. I cannot merge the two projects into one as I…
Crono
  • 10,211
  • 6
  • 43
  • 75
3
votes
1 answer

How to get C# code equivalent of VS Schema Compare tool?

I have multiple SQL Server databases that I would like to compare to one gold-standard database and produce a report/list with all of the differences between the two in terms of schema. This would be done automatically on a schedule. I need to be…
Matthew Rodgers
  • 133
  • 5
3
votes
1 answer

VS2015 Database Project: Turn off schema checking

I am trying to create a Database Project in VS2015 and get to build it. But I have errors like SQL71501: User: [UserX] has an unresolved reference to Login [UserX] Options are 1. To turn off any schema checking 2. Add Master Database as a Database…
Rohit Nampelli
  • 31
  • 3
3
votes
2 answers

Visual Studio 2010 - Schema Compare - Specify Database (Security) Schema

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.)…
Jason Irwin
  • 1,985
  • 2
  • 29
  • 42
3
votes
1 answer

Visual Studio Schema compare issue

In Visual Studio i changed a field name in data base project. IdInInGeo -> IdInIngeo After i do Schema compare but it's not recognized any changes in this table. In Schema compares's Options i can't find a any settings about fields register (maybe…
Kliver Max
  • 5,107
  • 22
  • 95
  • 148
3
votes
1 answer

Export schema compare upgrade script to transact-sql with visual studio 2012 premium

I have been blessed with Visual Studio 2012 Premium at work. One of the tasks I've been given is to do a schema compare between development and system test databases. This is all well and good, but when I generate the script to hand over to the…
Michael McCormick
  • 304
  • 3
  • 11
3
votes
2 answers

SSDT Refactor Rename is ignored by the Schema Comparison script generation

I right-clicked on a column name in a CREATE TABLE script and selected Refactor | Rename. It renamed the column and the expected entry appears in the refactorlog XML file. However, when I run a Schema Comparison from my project to my database and…
Mark Freeman
  • 1,155
  • 3
  • 24
  • 42
2
votes
2 answers

Schema Compare - How to take referenced projects into account?

I've created a database project and several databases projects that reference that project. I would like to use VS2008 Schema Compare to compare the schema of one of the databases to my development database. So far, so good. But when I check the…
Kees C. Bakker
  • 32,294
  • 27
  • 115
  • 203
1 2
3
…
8 9