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

  • Grant Fritchey (2/10/2016)


    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.

    😎 Well, I was being proactive as I knew someone was about to suggest this at some point when source control and databases was introduced.