schema-compare Questions
3
Solved
I have a SQL Project in Visual Studio 2017 and I'm using SSDT to update my project from a SQL Database, looks like this:
Often the database I'm using as my source is changing(often in small and ...
Twinflower asked 18/4, 2018 at 20:53
3
I am using Schema Compare feature in Visual Studio 2017 to compare a database with database project (.sqlproj).
If I apply some changes to the project it also adds blank lines to some of the schema...
Pictorial asked 20/4, 2018 at 14:59
2
Solved
I've been running a schema compare in a database project in Visual Studio 2017, when I do this I get the following message in the Error List tab:
Unexpected exception caught during population of...
Zygapophysis asked 1/11, 2018 at 14:39
4
I have a SQL Server database with the default schema and a custom schema. So for example two tables might be database.dbo.table1 and database.customschema.table2.
I want to keep the "customsch...
Elytron asked 27/10, 2016 at 14:22
13
Solved
Is it possible to compare two databases with identical structure?
Let say that I have two databases DB1 and DB2 and I want to check if there is a difference in data between them.
Demonology asked 26/1, 2011 at 12:54
4
Solved
In Visual Studio 2013, is there a way to ignore column ordering when doing a Schema Compare? I see that this feature was removed from Visual Studio 2012 (according to this: https://stackoverflow.co...
Battement asked 29/1, 2014 at 16:34
11
Up until today, I was able to use the Schema Compare feature in Visual Studio 2012 to update a database from a database project. But now, for one project I can do the compare, but the update button...
Manno asked 6/6, 2013 at 17:54
3
Solved
I am performing SQL Server schema comparison using Visual Studio 2017. I am pressing on "Generate script" button of Schema Compare utility and see the message
"Update scripts generated successf...
Okwu asked 21/6, 2018 at 23:32
3
While trying to update the database in SQL Schema Comparison in Visual Studio, I am getting the below error.
(48,1): SQL72014: .Net SqlClient Data Provider: Msg 50000, Level 16, State 127, Line ...
Wittenberg asked 27/12, 2016 at 10:35
3
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...
Immunity asked 7/6, 2017 at 17:35
1
I've created a database project in my solution in Visual Studio 2013 and imported a database from a SQL server. I then did a SQL compare; the source is the database, the destination is the database...
Arlaarlan asked 18/10, 2016 at 15:50
4
Solved
I would like to create a delta script from the database and my database project. The database as source and database project as target. The Update button works fine without any errors and my Error ...
Bronchi asked 23/10, 2017 at 11:52
2
I am attempting to use SQL Schema Compare in Visual Studio 2013/15 and am running into the problem that discluding tables from delete removes them from being processed at all.
The issue is that th...
Outofdoors asked 1/8, 2016 at 18:11
2
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].[add...
Autotruck asked 14/11, 2012 at 9:6
0
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 ...
Jodeejodhpur asked 11/11, 2015 at 20:22
3
Solved
I'd like to compare schemas between SQL Server 2012 and SQL Azure, but I get this error in Visual Studio 2013:
A project which specifies SQL Server 2012 as the target platform cannot be publishe...
Waaf asked 23/2, 2014 at 17:46
1
Solved
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 ar...
Ebbarta asked 16/7, 2015 at 14:7
1
Solved
I have a Visual Studio 2013 solution with 2 SQL Projects DB1, DB2.
DB1 has a stored procedure that references DB2.
If I use a .dacpac and synonyms in procedures
SELECT * FROM [$(DB2)].[dbo].[Ta...
Obviate asked 30/4, 2015 at 13:52
1
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 speci...
Mckeown asked 19/2, 2015 at 15:2
1
Solved
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 sche...
Dikdik asked 13/6, 2014 at 22:20
1
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 const...
Agglutinogen asked 31/10, 2012 at 16:28
1
Solved
VS 2010 had a way to save Schema Compare options so that they will be applied to all schema compares.
VS 2012 seems to only persist the options for a single compare; once I close the window, all m...
Ligniform asked 21/12, 2012 at 20:48
2
Solved
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 t...
Bunin asked 22/6, 2011 at 23:54
1
© 2022 - 2025 — McMap. All rights reserved.