Open Forum

Software for Splitting Large App Database

  • 1.  Software for Splitting Large App Database

    BRONZE CONTRIBUTOR
    Posted Dec 22, 2020 01:49 PM

    We have a client with a single very large app DB (+250 Gb) and over 1,000 companies in the database. 

    I wondered if anyone has heard of 3rd party software that can split out companies from one database to a separate new database(s).  

    I know Plumbline has a Database Merge product but we are thinking about the other way. 



    ------------------------------
    David Safstrom
    Senior Consultant
    NexTec Group
    Roswell GA
    ------------------------------


  • 2.  RE: Software for Splitting Large App Database

    TOP CONTRIBUTOR
    Posted Dec 22, 2020 01:54 PM

    I have done that before by writing SQL scripts. I'm pretty sure Price Brattin's (RIP) utilities, that Plumbline Consulting acquired, included this capability.



    ------------------------------
    Jonathan Van Houtte
    Architect
    XLstatements, LLC
    Clifton Park NY
    ------------------------------