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 answers
Related Questions in VISUAL-STUDIO-2013
- Alternative for nextafter when backporting to visual studio 2013
- Visual Studio 2013 Crystal report error "MIssing parameters Values"
- Visual Studio 2013 Crystal report 13.0.8 do not open
- Open Visual Studio 2012 solution in Visual Studio 2013
- SSRS DataTransform property in VS 2013 produces no output
- Virtual method with default parameter changed behavior
- why return nothing when i want to read password( CredentialBlob ) from credential manager in windows with type CRED_TYPE_DOMAIN_PASSWORD
- "This project is incompatible with the current version of Visual Studio" (VS2013)
- How to install AJAX in Visual Studio 2013
- "Package Installation" error on Visual Studio project load
- Choosing the user's installation folder of a program deployed with Visual Studio
- Running C++ dll in C# for calling functions
- Install multiple SAP Crystal Reports versions?
- Error "Cannot open source file" always occurs on Visual Studio Platform Toolsets v120_xp
- How to build Google test in Visual Studio 2013?
Related Questions in SQL-SERVER-DATA-TOOLS
- Column drop in dacpac
- SSDT unit testing of scripts
- SSIS.ReplacementTask after upgrading VS2019 to VS2022
- Run SSIS package through Server its working fine but that package I am running on my local system its not working
- How to use Project Level connection Managers in SSIS Script Task
- Performance difference depending on attribute order when using SSAS for data import in Excel pivot table
- How to pass a variable value in SSIS to Python Script : Execute Process task
- Cant get ManagedDTS version 15 folder even after installing SSDT for VS 2017
- SSIS Package Execution Fails with COM Class Factory and IClassFactory Errors in SQL Server 2019
- How to pre-process (handle blank "" values - not NULL) in Excel Source for SSIS package?
- Authentication using AccessToken / ServicePrincipal
- $(ProjectDir) in post deployment SQL files
- Multiple CSV files to Multiple tables with different schema in SSIS
- Visual Studio SSDT Database Project - add database reference without inheriting sqlcmd variables
- SSDT SQL Project for Synapse Set Scoped Configuration DW_COMPATIBILTY_LEVEL
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?
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)
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.