Post reply

Sql objects - TFS

  • October 23, 2015 at 5:44 am

    #321716

    Hi,

    I would like to maintain version control of the all the sql objects (sp, view , tables ) and maintain source code versions control. Please suggest a way to use TFS to maintain versions of sql objects. Also please suggest me the folder structure when using TFS.

    Thanks

    TJ

  • October 23, 2015 at 6:12 am

    #1835137

    if you have visual Studio 2012 , if you install the SSDT package from microsoft, you can create a new database project.

    that has a wizard to point to a database,w here it imports all objects as scripts.

    that can be then added to your TFS.

    if you are in VS2010, i think the same features are available in the "Ultimate" version of Visual Studio.

    it builds the folder structure for you, similar to what you see in SSMS: schema...then sub folders for tables/functions/procedures etc.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply