Wednesday, September 13, 2017

I worked with a Visual Studio Database project for the first time today.

In Visual Studio 2015, such a project will have a "dbo" folder and inside of this folder there will be folders for "External Tables," "Functions," "Stored Procedures," "Tables," and "Views" and the "Tables" folder has create scripts for the various tables. If you splice in a column here there is a RedGate Data Compare flavored means for generating a comparison script to be deployed to an environment that has everything but the bit you are bolting on.

No comments:

Post a Comment