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

Update database schema from entities (without using entity framework migration) in .net core

I'm looking for a tools (library or a nuget package) that gives me the difference script (in SQL server script format (as string or as a file) ) between my entities and my database tables (SQL server) and have the capability to automatically run…
Code_Worm
  • 4,069
  • 2
  • 30
  • 35
2
votes
0 answers

SSDT exclude fill factor from table definition

SSDT has an option to ignore fill factor (IgnoreFillFactor). But what it actually does is: it doesn't flag object as changed if there are only fill factor changes. If there are some additional changes fill factor will be published together with…
Ramūnas
  • 1,494
  • 18
  • 37
2
votes
1 answer

Cannot select target in SQL Server Schema Compare, Visual Studio 2017

I'm having an odd problem which I haven't been able to find a solution for. Suddenly I am not able to select a Target or Source in Schema Compare in VS2017. When I click the Combobox nothing happens. It is still possible to do a Data Compare and SQL…
jhe
  • 170
  • 2
  • 11
2
votes
1 answer

Azure Sql database schema missing constraints after schema compare

I created a blank SQL database in Azure. From Visual Studio 2017, I performed a Schema Compare, and updated the blank Azure database to my schema. There were no errors so I didn't check everything was exactly the same. I setup replication and…
Ian
  • 2,898
  • 1
  • 27
  • 29
2
votes
2 answers

C# Automatic Schema Compare on list of SQL Database and Update

May I know if there is any library in .Net that can allow me to pass in 2 connection string and do Schema Compare and update? The reason I need this is because I maintain a golden database which deploy to multiple databases for different customers.…
TPG
  • 2,811
  • 1
  • 31
  • 52
2
votes
2 answers

Excluding schema-level permissions in SSDT comparisons

TL;DR: Is it possible to exclude permissions granted on a schema when doing a schema comparison in Visual Studio 2013? I have a user account that is only present on production servers, and an identical user that is only on non-production servers. …
nicedream
  • 21
  • 1
  • 3
2
votes
2 answers

msbuild schema compare - Empty target

I am looking at using MSBUILD from a command line to run the schema compare (*.scmp) Within the solution we have several databases and the team aren't always that great at remembering to check changes (stor procs, tables etc..) into the solution.…
Taylby
  • 31
  • 7
2
votes
1 answer

Can I exclude a custom schema from a Schema comparison in SSDT?

We have a SQL server database that is very dynamic and is always creating new and dropping existing tables from a custom schema called 'temp' (we have a dbo schema and a temp schema). We also use SSDT to maintain and monitor changes in our schema…
Palps
  • 568
  • 9
  • 20
2
votes
1 answer

Can schema be ignored in object names in VS 2010 Schema Compare?

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.
Daniel
  • 47,404
  • 11
  • 101
  • 179
2
votes
1 answer

SQL Server Data Tools Ignores Refactor on Schema Compare

I'm having a seemingly identical problem to what is described here: SSDT Refactor Rename is ignored by the Schema Comparison script generation. Essentially, the refactor component of SQL Server Data Tools is not working on schema comparison/update.…
Dan Forbes
  • 2,734
  • 3
  • 30
  • 60
2
votes
2 answers

Is there anyway to set SQLCMD variables in VisualStudio Schema Compare

I'm using vs2013 data tools and trying to do comparisons of my database project and databases in different environments. But my tsql code uses synonyms to access different databases I can set this up with publish files as I can set each SQLCMD…
Trubs
  • 2,829
  • 1
  • 24
  • 33
2
votes
2 answers

Schema Comparison :: Create Schema [NT AUTHORITY\SYSTEM]

When running a schema comparison between my Live DB (set as source) and DB Project (set as target) to ensure code is up to date with what's made it to production I'm seeing the following statement: CREATE SCHEMA [NT AUTHORITY\SYSTEM] …
JohnLBevan
  • 22,735
  • 13
  • 96
  • 178
2
votes
3 answers

Oracle Data Tools (ODT) - schema compare

We are wanting to source control our Oracle Schema - as we have a number of SQL Server databases on our estate we would like to use a common tool - for the SQL Server databases we use Visual Studio 2010 / dbpro which nicely source controls each…
Travis Ingram
  • 387
  • 5
  • 21
1
vote
1 answer

Visual Studio 2010 - How can I control the order of schema updates when using schema compare?

I've been attempting to use Visual Studio 2010 schema compare to take updates from a Dev database and move it to a UAT environment. The compare itself works fine, but the tool continually orders the update scripts incorrectly. It will try to update…
James Osborn
  • 1,275
  • 7
  • 12
1
vote
1 answer

VS SchemaCompare: Making Table Updates

Does anyone know how the SchemaCompare in Visual Studio (using 2010 currently) determines how to handle [SQL Server 2008R2] database table updates (column data type, optionality, etc)? The options are to: Use separate ALTER TABLE statements Create…
OMG Ponies
  • 325,700
  • 82
  • 523
  • 502
1 2 3
…
8 9