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

Is any tool for database schema comparison via C#

I need to build job which will compare two databases and if there are some changes it should report about it. I have found 1) Red Gate API tool - too expensive 2) https://github.com/schambers/fluentmigrator - not exactly what I need 3)…
Sergey
  • 7,933
  • 16
  • 49
  • 77
0
votes
1 answer

Visual Studio 2010 Ultimate Crashes when I click new schema comparison

As the title says, I am using a full version of VS2010 Ultimate and everytime I try to do a schema comparison VS crashes. The debug error is: Unhandled exception at 0x75549617 in devenv.exe: 0xE0434352: 0xe0434352. Anyone had this issue and can you…
JamesStuddart
  • 2,581
  • 3
  • 27
  • 45
0
votes
1 answer

Deleting Database Connection Strings in Visual Studio 2015

I'm using Schema Compare but whenever I switch databases I see a list of old schemas as well as the ones I want to use. How do I remove the old ones? My current solution is to update the old schema to mirror one I want to keep and then it…
Matt McCabe
  • 2,986
  • 2
  • 22
  • 29
0
votes
2 answers

VS 2013 strange behavior in T-SQL project

I am experiencing weird errors when trying to build the project from db solution. EG. I have a table CREATE TABLE [dbo].[partner2_log_status] ( [rec_id] INT IDENTITY (1, 1) NOT NULL, [log_status] INT NULL, …
evictednoise
  • 587
  • 1
  • 7
  • 19
0
votes
1 answer

How can one get visual studio to do a simple change instead of a drop/add when altering database table columns?

Simply put: I am trying to use a visual studio database project to update my sql server database I change the names of the table columns by using the refactoring tool Once the column names are changed I do a schema comparison before making any…
brykim1
  • 1
0
votes
1 answer

Schema compare between project and snapshot

I use Visual Studio 2013 with SSDT to develop my database projects. Some projects within solution have dependencies on others. I create deploy/update script with Schema compare tool. I find differences between current project state and the latest…
Andrey Gurinov
  • 2,825
  • 1
  • 20
  • 23
0
votes
1 answer

What is the best way to use values from a dropped column in a post deployment script

We currently use Database projects during automated builds to ensure our test and development databases are in sync with source code. During the publish profile, we have noticed a problem which isn't totally covered by the workflow we're currently…
dougajmcdonald
  • 19,231
  • 12
  • 56
  • 89
0
votes
1 answer

How to merge two database schemes using toad

I use toad for sql server to compare databases. Is it possible to merge results between 2 database schema changes?
Inbal
  • 909
  • 2
  • 28
  • 46
0
votes
1 answer

VSDBCMD generates an error when running in PowerShell

We are running VSDBCMD to generate a diff sql script between our database project and our staging database. VSDBCMD is executed locally on staging server and is started by a powershell script from a remote host. When running the script locally…
pakerblom
  • 23
  • 3
0
votes
0 answers

Schema comparison in VS2012

In VS2012 I have two SQL Server projects imported from Scripts (*.sql). Is it possible to compare these two schemes and generate SQL script for the differences?
Mr. Pumpkin
  • 6,212
  • 6
  • 44
  • 60
0
votes
0 answers

SQL Schema Compare Not Creating CCDR scripts

I am using Visual Studio 2012 and trying to run a schema compare using the SQL tools. The only difference between databases is the addition of a column for one table. When I go to generate the script, it is only giving me an ALTER statement, not a…
RJP
  • 4,016
  • 5
  • 29
  • 42
0
votes
1 answer

Is there any way to schema compare with a SQL CE database?

I've been developing a WPF desktop application that uses a SQL Server Express 2012 database. I'm now thinking of trying SQL Server CE, in an attempt to simplify database install/deployment, and wondered if there was any way I can "populate" the CE…
Andrew Stephens
  • 9,413
  • 6
  • 76
  • 152
0
votes
1 answer

Schema Crawler issue in sc.sh

I am trying to get a text dump of Oracle Database schema using SchemaCrawler utility from SourceForge. Supplied the below args at command line ./sc.sh -driver=oracle.jdbc.driver.OracleDriver -host= -port= -database=iknowit…
HungryForKnowledge
  • 289
  • 1
  • 8
  • 18
0
votes
1 answer

Comparing Oracle 10g and Oracle 11g Schema

I have a task at hand wherein we need to compare two database schemas at two different versions. Actually an application has been upgraded to use Oracle 11g , older version of the application used Oracle 10g. Basically what needs to be checked is…
HungryForKnowledge
  • 289
  • 1
  • 8
  • 18
0
votes
1 answer

SQL Azure Data Sync service and schema update (Visual Studio Schema Compare)

I have a local SQL database (database first EF application) and an Azure database which are synced by the azure data sync service. Now what do I have to do to when I update the local schema of an table? Of course I have to update the schema in the…
daniel
  • 34,281
  • 39
  • 104
  • 158
1 2 3
…
8
9