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. Instead of renaming a table, for instance, the table with the old name is dropped and the table with the new name is created. Unfortunately, I do not see an accepted answer to that question. I found a similar question, which seems to be have been asked by the same person on MSDN; see: Refactor Rename is ignored by the Schema Comparison script generation. Again, it doesn't look like an acceptable answer was proposed. I would really like to figure out how to get this feature to work. Does anyone have an idea?
SQL Server Data Tools Ignores Refactor on Schema Compare
1.9k Views Asked by Dan Forbes At
1
There are 1 best solutions below
Related Questions in VISUAL-STUDIO-2012
- Pass multiple account variables to single parameter
- Cannot find InvalidCastException in C# Application
- Upgrading separate Project Collection Database to new TFS Version
- How to add asp.net mvc5 to visual studio express 2012 edition?
- How to deploy Windows app with SQL Server database?
- The merge tool is not showing when call Workspace.ResolveConflict method in TFS 2012
- Toggle groups based on a parameter
- SQL server 2008 with 2012 Data tools
- Accessing parent parameters from child package SSIS 2012
- How to add parameters in the comments of a method in Visual Studio after it has been generated?
- No warning on deleting a forward declared pointer (Visual Studio)
- EWS Service.FindItems() throws an exception when using SearchFilter.IsEqualTo
- Label change when button click
- SharePoint 365 Development - Visual Studio 2012 - Actions4 file
- Team Foundation 2012 not recognising changes in vb6 app
Related Questions in SQL-SERVER-2012
- Combine two rows based on common ID
- Data streams in case of Merge
- Defining which network to use for SQL Server 2012 Management Studio
- Insert into Change Log based on Trigger After Update
- Change column values based on another column in same table
- Using a Table of Column Definitions to Create an Insert Query
- How to deploy Windows app with SQL Server database?
- t-sql update XML element value based on another element value
- SQL Server union not sorting correctly
- Sql mapping problems
- Is there a way to export huge amount of data (more than a million rows) from SQL Server to csv?
- SQL Server 2012 or 2014 Failover Cluster - Change Instance Port Number
- SQL breakout date range to rows
- Declare table dependency in stored procedure when using T-SQL
- How to update the database once when the timer expires?
Related Questions in SQL-SERVER-DATA-TOOLS
- Visual Studio 2013 Build Error: Incompatible versions of SQL Server Data Tools and database runtime components are installed on this computer
- Sql Server Data Tools Data Comparison fails when connecting to Azure
- How can I update a SQL Server Project in Visual Studio 2013 if the deployed database is changed from another source?
- SSIS Expressions setting two variables
- Difference between InitialCatalog and Database Name
- Manage SSDT project file properly with version control (*.sqlproj)
- SSIS Package Stuck at "Created Execution" Status
- Is it possible to move triggers into their own file in an SSDT project?
- Change logical and physical file name when deploying dacpac
- Is it possible to update a SSDT DB project from a database?
- SSDT implementation: Alter table insteed of Create
- SSDT in SQL Web on Azure VM
- import Excel into SQL Server using SSIS
- Using Visual Studio 2015 CE to Debug stored procedures called from .NET code?
- SSDT Database projects Code Analysis integration with SonarQube
Related Questions in SCHEMA-COMPARE
- How to ignore data loss warning while schema comparison?
- Azure Sql database schema missing constraints after schema compare
- How to compare data between two databases in PostgreSQL?
- Transferring saved data connections between Visual Studio installations
- How to make Visual studio schema comparison igonore database references
- DB2 SQL query to compare 2 schemas
- SQL Schema compare - column level actions
- SQL Schema Compare Not Creating CCDR scripts
- RedGate SQL Compare 9 command line - STATISTICS_NORECOMPUTE
- Oracle Data Tools (ODT) - schema compare
- Postgres schema compare that works with declarative partitions
- Visual Studio 2013 SQL Schema Compare: Ignore Column Order
- Export schema compare upgrade script to transact-sql with visual studio 2012 premium
- Is there a way to update a Database Project(or dacpac) from a live SQL Server Database?
- Apply SQL Server schema after 'schema compare' show error
Related Questions in REFACTORING-DATABASES
- Rename/Refactor database elements - only scripts exists but not database
- How to start flyway script versions over
- Is there something like a "column symlink" in Oracle?
- How to rename SQL table column name(s) and not break stuff
- How to deal with SSDT `refactorlog` merge conflicts?
- In sql server, is there any way to check whether the schema change will impact on the stored procs?
- Does a version control database storage engine exist?
- SQL Server Data Tools Ignores Refactor on Schema Compare
- ArcSDE Database Refactoring Tool options
- Db4o - how to rename a field in one step?
- How many tables/sprocs/functions in a database is too many?
- SQL Server 2016 - Get NULL values from a table using a Stored Procedure
- Best Practices for MySQL Encryption?
- Refactoring Auto-increment ids to GUIDs in **SQL DB
- SQL, How to change column in SQL table without breaking other dependencies?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Figured out the cause of this problem. I noticed that when doing a schema compare against my SQL Data Tools project and a different (yet essentially identical) database, the refactor component was in fact considered. I took a look at the generated SQLCMD script, and at the bottom saw lots of entries that looked like this...
IF NOT EXISTS (SELECT OperationKey FROM [dbo].[__RefactorLog] WHERE OperationKey = 'ce3d4c93-c1c4-4967-9cd5-0048d1e7d22f') INSERT INTO [dbo].[__RefactorLog] (OperationKey) values ('ce3d4c93-c1c4-4967-9cd5-0048d1e7d22f')I took a look at the database on which I was having problems and sure enough, under System Tables in SS MS, I found dbo.__RefactorLog. After truncating this table, the schema comparison again showed the proper refactoring.