What are the challenges you face when working across database platforms? Take the survey

Save Selected objects as Scripts


I am testing the new SDK 7 and i was able to save a database to script folder following the samples.
Now, I want to sync Live Database with scripts.
We save Scripts in TFS and each developer has a local database and makes changes to their local database and after testing with our app they try to sync that with the script files from TFS. Right now, syncing scripts is done manually (scary i know).

my solution is to give them this utility where they can select their local database and compare that with scripts folder and it will display list of tables/views/stored procedures that are different and hit the Sync button which will update the script files and later they can check in script files.

Please let me know.



Sign In or Register to comment.