I have a SQL Server Project in Visual Studio 2013. I created it by importing the database from a preexisting db. We have other devs who may have made changes to the database using ssms or some other means. How can I update my SQL Server project to reflect these changes? Is there a simple way that I'm missing or do I have to modify/add all of the changed tables manually?
How can I update a SQL Server Project in Visual Studio 2013 if the deployed database is changed from another source?
1.9k Views Asked by wakers01 At
1
There are 1 best solutions below
Related Questions in VISUAL-STUDIO-2013
- couldn't copy pdb file to another directory while consuming wcf web service
- XSD.exe Generating Classes with type Object instead of XSD defined type
- Can I deploy multiple instances of my application on the same windows phone?
- Cannot "Go To Definition" in Visual C++ 2013
- Get date Minus 1 day but at exacty 4 AM
- How to Create unit test cases from Dll in VS 2013
- Can I use free() formally in VS2013?
- Is it okay to cancel Visual Studio installation? And can I resume it?
- Add a picture to Picture Control in a dialog box (error RC2108: expected numerical dialog constant)
- Within a .vcxproj file what are the possible values for the <ConfigurationType> and what do those values mean?
- What is the latest .NET Framework that works with WCF RIA Services and EF 5.0 in a Silverlight 5 LOB application?
- Labels turned dark when printing as graphics in vb 2013.
- WiX and custom extensions for primary output?
- Avoiding installation of IIS Express 8 during an unattended install of Visual Studio 2013
- VS Database Project User Creation Error
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
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?
So, after a ton of googling that didn't yield very good results, I continued to play around with the project and figured out that you can use Visual Studio's schema comparison to update the SQL Server Project.
Go to tools -> SQL Server -> New Schema Comparison Select the source database as your source. Select your SQL Server Project as the target. Run the comparison and update the target from the schema compare.