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
7
votes
1 answer

Why does Visual Studio 2013 Schema Compare include Permission Statements for each object definition and treat them as different from the project?

I recently updated one of my projects to Visual Studio 2013. The update changed my .dbproj into a .sqlproj to make it compliant with the new SQL project format. After the conversion, I ran a schema compare against my SQL project and my SQL 2008…
Aaron Hawkins
  • 2,611
  • 1
  • 20
  • 24
7
votes
1 answer

Include default constraint names in generation of update script

I'm using a SQL Server Database Project with Visual Studio 2012 and have the following problem when comparing and generating an update script: In Visual Studio, I add a column with a default constraint, for example: [NewColumn] NVARCHAR(50)…
marapet
  • 54,856
  • 12
  • 170
  • 184
6
votes
2 answers

Can Visual Studio 2010's Schema Compare feature be configured to default to 'Non Skip Objects'?

I find that in almost every case, I change the filter of the schema compare results pane to 'Non Skip Objects' so that I see only those objects that have changed. Is there any way for this filter to be set as the default (rather than 'All')?
Scott Munro
  • 13,369
  • 3
  • 74
  • 80
6
votes
3 answers

Extract whole schema from oracle database to another (java) (automation)

I am trying to find a solution that I can hopefully implement a regression test from one oracle database against another oracle DB via data. Example: Database A adds a table, I want to take the data from database A and import it into database schema…
Mike3355
  • 11,305
  • 24
  • 96
  • 184
6
votes
3 answers

SQL Server Compare Schema in Visual Studio 2017

I am attempting to compare schemas of two databases on the same server. The two databases are named benchmarkdb and benchmarkdb_dev. In Visual Studio 2017, I go to Tools > SQL Server > New Schema Compare... From both drop down menus labeled "Select…
ccbadger
  • 123
  • 1
  • 1
  • 7
6
votes
0 answers

Visual Studio 2015 crashes on Schema Compare

Every time I try to do a Schema Compare against my local database in Visual Studio 2015, Visual Studio crashes and restarts itself. I've already tried restarting my PC and deleting and recreating the database (by restoring it). I am running Visual…
Josue Rocha
  • 393
  • 3
  • 10
6
votes
1 answer

Schema Comparison Detects Differences for Identical Stored Procedures

I am using the Visual Studio 2012 schema comparison tool to diff an actual database with a Microsoft SQL Server DAC Package File (dacpac). The expectation is that the database and the file are "equal". However, the schema comparison reports…
Dan Forbes
  • 2,734
  • 3
  • 30
  • 60
6
votes
1 answer

VS2013 database project - ignore schemas/tables matching filter?

I have a database which includes many cached/generated tables. I'd like to exclude these (permanently) when I do a schema compare. Is there any way to configure the schema compare to ignore a specific schema or, even better, a specific object name?…
Josh M.
  • 26,437
  • 24
  • 119
  • 200
6
votes
2 answers

Is there an option to parse SQLCMD-variables doing a comparison in Visual-Studio schema-comparison?

It looks like Visual Studio Database Project does not parse SQLCMD-variables doing a schema-comparison. All my synonyms looks like CREATE SYNONYM [dbo].[addressesExtDB] FOR [$(ExtDB)].[dbo].[addresses]; but they keep be reported as different from…
Peter
  • 489
  • 3
  • 16
5
votes
2 answers

VS 2015 Schema Compare differences not shown but are detected

When I do a schema compare on an Azure database, the schema compare tool says "Comparison Complete. Differences Detected" at the bottom, but the center screen remains empty except for the message: You can compare a source schema with a target…
Clint
  • 2,696
  • 23
  • 42
5
votes
1 answer

Is it possible to ignore NOT FOR REPLICATION in Visual Studio's Schema Compare?

I have two environments: dev and test. Dev has a single SQL instance. Test has three which use merge replication. When I use Schema Compare between dev and test, every table is always flagged as different because the tables in Test have a few…
Ivy
  • 887
  • 1
  • 7
  • 25
4
votes
1 answer

Vs2017 Schema Compare Doesnt Detect changes that exist (only on some machines)

We've run into a problem on a couple of our development team members systems that I'm hoping someone has come across before. We are using VS2017 and have our database in a database project. On two of our team members systems, Schema compare has…
Dave Leonard
  • 71
  • 4
4
votes
0 answers

Database Schema Compare : Published Script Without Command Mode

My question is regarding to SQL schema compare. Database Schema Compare When i generate script using SQL schema compare, script is generating in below format. /* Deployment script for Student This code was generated by a tool. Changes to this file…
yogesh
  • 45
  • 1
  • 8
4
votes
1 answer

SSDT How can I create a new database from a DACPAC file?

Currently using SqlPackage.exe cmd line tools to generate a script, by comparing DacPac file with a target database. This will Create the database if it doesn't already exist. We now want to switch this to use the Microsoft.Data.Tools.Msbuild Nuget…
Fish
  • 138
  • 1
  • 7
4
votes
1 answer

sqlPackage.exe not including dropped stored procedure in deployment script

I have a SQL Server database project in Visual Studio and I have dropped an existing stored procedure. I also have a database locally where that exact stored procedure exists. When I run a schema compare from within Visual Studio on both, in the…
dhughes
  • 645
  • 1
  • 7
  • 19
1
2
3
…
8 9