Dividing a SQL Database into Two

Posted on 2007-07-19
Last Modified: 2008-01-09
Hi -

I have a company with several divisions on a SQL 2000 database.  The database contains product information, sales, customers, etc. - basic e-commerce stuff.  Total size is a little under 1GB.  One of the divisions has been spun off, and I need to split the database so that the records pertaining to that division are replicated in a new database, and completely removed from the existing database.

What is the best way to accomplish this?


Question by:okanagan
    LVL 5

    Accepted Solution

    I would create a new database to represent the portion of the company that is being spun off. Take a backup of your production database and restore it to the newly created database. Remove the data from each database that doesn't belong and you should be set to move the new database to a server for the new company and your data will be clean. (This is assuming you can easily identify and remove the data from each database).
    LVL 35

    Assisted Solution

    by:David Todd

    Just as a check, I'd keep the original database, and create two new databases.

    ie TotalCompany - original database
    DivisionX - division that is being spun off
    Others - remaining divisions.

    That way TotalCompany is still there for reporting/reference/lookup/etc. Obviously want to set it to read-only. Your application may not like this. Some applications write to a loggedIn table ...

    My 10 cents worth

    Author Comment

    Thanks to both - I figured a backup was in the cards, but dtodd's idea is a good one.

    Thanks again,


    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.
    Viewers will learn how the fundamental information of how to create a table.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now