locked
Installation and Update of a web application RRS feed

  • Question

  • User1555917662 posted

    We have an web application  under development. ASP.net MVC 3.0 with .net framework 4.0 and the database is in sql server 2008 the application runs in IIS 7.0 

    How can we create an upgrade patch in terms of new developments in the database. Currently we create sql scripts and send it to our release team to run the scripts on the database. The issues with apporach are

    1. time taking for the release team,

    2. we are unable to track the data base versions

    The updates may include adding extra coloumns, Stored procedures, Views, new tables and also in some cases default data.

    Is there any easy way to do this like creating an update installation package in terms of database changes? 

    Wednesday, February 26, 2014 7:45 PM

Answers

  • User-1454326058 posted

    Hi hemanth,

    Thanks for your post!

    For your requirement, I suggest that you could create a database project and check into the TFS. After that you could track the versions.

    For the database project, you could import the remote database to the project and you could update the remote database directly by publish the database project.

    Thanks

    Best Regards  

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, February 28, 2014 12:42 AM

All replies

  • User-1454326058 posted

    Hi hemanth,

    Thanks for your post!

    For your requirement, I suggest that you could create a database project and check into the TFS. After that you could track the versions.

    For the database project, you could import the remote database to the project and you could update the remote database directly by publish the database project.

    Thanks

    Best Regards  

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, February 28, 2014 12:42 AM
  • User1555917662 posted

    Thanks a lot it did help us to stream line our versions.

    Wednesday, March 5, 2014 6:59 PM