Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Best way to move data from one db to another and maintain relationships ? RE: Best way to move data from one db to another and maintain relationships ?

  • June 20, 2013 at 1:49 pm

    #1626096

    William Plourde (6/20/2013)

    So a person could move from db A, to B to C to D etc?

    Yep, that is correct. Assuming 6 dbs out in the future. A person (and all their related data) can move from any db to any other db. Possibly more than once over time due to business logic.

    Just curious, why different DB's? Why not partition the tables instead and save the headache?