Stack Overflow
Stack Overflow

Questions tagged [database-comparison]

18 questions
6
votes
2 answers

Opening .scmp file in Visual Studio 2015 opens as XML and not as comparison UI

I'm opening a Database Schema Comparison (.scmp) file and the file opens in Visual Studio as XML. However, the need is for the file to open in the Server Data Tools tab. I have tried opening from Visual Studio and Windows Explorer. Using Visual…
AudioDev
  • 260
  • 3
  • 11
2
votes
0 answers

The Schema Compare tool in Visual Studio has stopped working properly, giving "cannot be overwritten. It is being used by database 'DbName'" errors

Full Error: 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\TestSource.mdf' cannot be overwritten. It is being used by database…
LaserBeak
  • 3,257
  • 10
  • 43
  • 73
2
votes
2 answers

Compare 2 database

I have 2 identical databases. abc15 and abc18. But one of the database has one extra table and I need to find that. I thought the following query should return it, but is it not showing the record that I expect. select * from…
shantanuo
  • 31,689
  • 78
  • 245
  • 403
2
votes
3 answers

Simple database table comparison using DataTable.Merge and DataTable.GetChanges

We are converting our application from using Sql Server Express (let's call this version 3) to Sql Server Compact Edition (let's call this version 4). I am trying to make sure that upgrades from previous versions (versions 1 and 2) are the same in…
Dave Mateer
  • 17,608
  • 15
  • 96
  • 149
2
votes
2 answers

DB Comparison tool that I can schedule

I'm after a DB Comparison tool for SQL Server that allows me to do the following: Schedule a comparison to happen on a recurring schedule Email me the results (in a nice readable format and not the generated script) Allow me to exclude/include…
Katerina Antonopoulou
  • 23
  • 3
1
vote
1 answer

Database compression in postgres

As the database size keeps growing, as part of business requirement, we have been asked to compress data for our prod database. Need to know what are some disadvantages of database compression in postgres.
Channa
  • 742
  • 17
  • 28
1
vote
1 answer

PSQL query to comapre data from two instances of a database

I have two instances of the same database from different days. All tables from one day are called tableA* and from the other tableB*. I would like to compare data to see what have changed. I would like to select all rows that don't match exactly. So…
madasionka
  • 812
  • 2
  • 10
  • 29
1
vote
3 answers

SQL Database Comparison

I have two databases: DBTarget and DBTest. I've run several custom scripts on DBTest, so now DBTest and DBTarget should be identical in every way (Tables, Values in tables, Columns, SPROCS, etc.) Question: Is there an easy way to compare these two…
Onion-Knight
  • 3,477
  • 7
  • 31
  • 34
1
vote
1 answer

Compare application database created in SQL Server and Oracle

I looked around for this task I have on my hands but did not find anything helpful. I am primarily a Java person with sound knowledge of database from software development point of view. I do have some knowledge of DBA functions with what can and…
Gauzy
  • 711
  • 3
  • 13
  • 26
0
votes
1 answer

Schema Compare Visual Studio 2010 - adding new object do database project to main directory

During conversion old, 2008 database project into 2010 database project using features like Partial Project reference, I encounter problem with Schema Compare in VS 2010. After successful merge new object from DB into DB project, files are being…
Rafał Warzycha
  • 561
  • 3
  • 18
0
votes
1 answer

Compare Oracle Table with legacy data that has spaces

I have a legacy goldengated table- Let us call it LEGACY_TABLE. This has 15 columns and 5K rows. This LEGACY_TABLE has column values with a lot of trailing spaces. My new table, let us call it NEW_TABLE. I created it manually by exporting data and…
Marco
  • 83
  • 1
  • 10
0
votes
1 answer

Can not compare Azure database in Visual studio 2022 schema compare

I'm trying to compare the Azure SQL Managed instance to my local database project. But when I make a selection of the database "Ok" button is not getting enabled. This used to work a month ago but all of a sudden it stopped working. It's an issue…
Sachin jeev
  • 201
  • 4
  • 14
0
votes
1 answer

How to compare replication in Big Data

Problem statement - Replications are usual tasks in industry and its equally important to verify the replication, if replicated database has same data as same as the original database. Example - I have database D1 and for testing purpose I am…
Anand Chavan
  • 4,338
  • 6
  • 23
  • 27
0
votes
1 answer

How to verify large postgresql Databases running different version have the same data without dumping

How Would I verify that the data in a 8.3 postgresql DB is the same as the data in a 9.0 DB When I did a sql dump on a example table there we3re many differences that showed but this was due to 9.0 truncating 0's on the end and begining of date…
Arthur
  • 3,376
  • 11
  • 43
  • 70
0
votes
3 answers

How to compare same DB for their Schema and Tables?

I am using SQL SERVER 2008 R2, I have two same DB, ABC (with only structure like schemas, tables but no data in the table) ABC1 (with schemas, tables and data in the tables) How can I compare #1 & #2 for their Schema and Tables, do we have…
Vikrant More
  • 5,182
  • 23
  • 58
  • 90
1
2