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

Avoiding "schema drift detected" errors in SSDT comparisons

I'm trying to update a SQL Server project in Visual Studio 2019 by using the SSDT schema comparison. My source is a running database server, the destination is the VS SQL Server project. When the comparison is done and I click "Update", I get the…
nicedream
  • 21
  • 1
  • 3
0
votes
1 answer

What would be best security for "Microsoft SQL Server Data Tools, Schema Compare"

When running "Microsoft SQL Server Data Tools, Schema Compare" then I would like to run as a user that is unable to change anything. It looks like the SQL it mostly write is stuff like select whatever from sys.something Is there a group in SQL…
Thomas Koelle
  • 3,416
  • 2
  • 23
  • 44
0
votes
1 answer

Add Primary Key Constraint keeps appearing in schema compare but won't commit to the database project

I am working on a database project in azure data studio. I added a primary key constraint to an existing table. When I update the project from the database, the schema compare picks up on the change. +ALTER TABLE [dbo].[tableName] +…
Nick
  • 58
  • 6
0
votes
1 answer

Apply SQL Server schema after 'schema compare' show error

Versions in use: SQL Server 2016 Azure Data Studio 1.36.2 SQL Server Schema Compare 1.13.1 Problem: there is something wrong with my Azure Data Studio apply schema to SQL Server 2016. It say I'm not the login manager but there is no login manager…
Sean.Lin
  • 1
  • 2
0
votes
1 answer

How to handle Odata metadata changes in Azure DataFactory/Database?

Current situation: I use an Odata connection to receive data to fill a database. I'm not the owner of that connection. When the supplier releases a new version, there might be changes to the tables, columns and datatypes coming through this…
user19239121
  • 21
  • 4
0
votes
0 answers

Is there a way to update a Database Project(or dacpac) from a live SQL Server Database?

So the scenario here is that I have done a bunch of work (i.e changing table names, rewriting and renaming SPs, synonyms etc) in a database within our live DEV SQL server. Now I want to move all my changes to our version control where this same…
Reemz
  • 51
  • 4
0
votes
1 answer

Schema errors with .NET SqlMembershipProvider

Visual Studio 2010 Ultimate MS SQL Server 2008 Default .NET SqlMembershipProvider (aspnet_Users, aspnet_Memmbership, etc...) I set up a database project to keep the database synced between environments and keep it versioned. The database has a few…
Jeff
  • 13,943
  • 11
  • 55
  • 103
0
votes
1 answer

Using Oracle partition and storage options with Redgate Schema Compare fails

I'm trying to introduce new audit tables for our project. In the deployment process we use redgate's Schema Compare for Oracle (version 4.0.8.420). The table looks something like this: create table MY_SCHEMA.MY_TEST_AUDT ( TEST_ID …
Alain Sollberger
  • 21
  • 4
0
votes
1 answer

Postgres schema compare that works with declarative partitions

Are there any tools that can compare the schema of two Postgres databases to an SQL script and is able to handle declaratively partitioned tables correctly? I've been searching high and low. DataGrip 2018.2 is able to generate DDL that correctly…
Greg Graham
  • 473
  • 7
  • 18
0
votes
1 answer

Oracle Developer Tools for Visual Studio 2017 (ODT)

I have created an Oracle Database Project Version 2 on visual studio 2017 and imported an existing database to the project to obtain the database schema on my project, and I got an SQLfile for such object in my project. The problem is when I'm…
M.M
  • 21
  • 3
0
votes
0 answers

Comparing schemas ignoring the schema name

I'm using the SQL Server Data Tools to compare the tables two schemas. The schemas are similar and should be adapted to be the same. Now my problem is, that those two schemas are differently named. Example: [sourceDB] [FOO].[table1] …
André Stannek
  • 7,773
  • 31
  • 52
0
votes
1 answer

SSDT: How to configure SchemaCompare Object settings in code

How to edit the SchemaCompare Settings in the SchemaComparison object? $SchemaComparison = [SchemaComparison]::new( $SourceEndPoint, $TargetEndPoint ) $SchemaComparison.Options = $DeployOptions I am particularly looking to Remove Database options,…
user5855178
  • 567
  • 1
  • 7
  • 17
0
votes
1 answer

Visual Studio 2013 crashes on SQL Select Source/Target in SQL Schema Compare after Windows 10 upgrade

With an existing schema compare file, or a newly created one. Tried to change source or target via: Menu: "SQL" Choice: "Select Source..." OR "Select Target..." Visual Studio 2013 then crashed with message: "Microsoft Visual Studio 2013 has stopped…
jgoerke
  • 101
  • 1
  • 3
0
votes
0 answers

SQL Server - database option "PageVerifyMode = 3" - Any reference for this?

I'm comparing two different schema with Visual Studio 2010. I got a difference in the database options, specifically: PageVerifyMode = 3 -- my source object PageVerifyMode = 1 -- my target object Two questions here: 1.How do the option impact the…
Marcellinov
  • 311
  • 7
  • 18
0
votes
2 answers

How to view history of database updates

If I have a database project that's connected to an Azure Sql db v12, is there a way to see a history of the "Schema Updates" I've run on that database? Similar to a Git history of commits? I know there's something called a refactorlog and I…
Willwsharp
  • 702
  • 1
  • 7
  • 25
1 2 3
…
8 9