Home Forums Database Design Design Ideas and Questions Database design to merge many different product databases into a single database RE: Database design to merge many different product databases into a single database

  • Muhanned Maayeh-445298 (2/10/2016)


    Grant Fritchey (2/10/2016)


    Muhanned Maayeh-445298 (2/10/2016)


    Grant Fritchey (2/10/2016)


    Be prepared for a lot of friction. It's actually difficult to coordinate releases of this type.

    I certainly hope not but, I think these releases will have to consider design in more detail to assure a change for one product does not in adversely impact another. You are correct it will not be easy.

    If you're going down this road, make sure you set up very good automated testing. I'd suggest getting continuous integration set up. That requires doing your development out of source control. But all this will get the process in hand and will help reduce or mitigate the friction.

    Yes good point. We will see about doing this we already purchased some licenses for Redgate SQL Source Control and hope that will help track our changes by who and when with comments.

    Ha! Well that's good news. I wasn't even going to bring up how to get your database into source control.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning