Post reply

duplicating a data base

  • October 23, 2005 at 12:55 am

    #166014

    hi

    ive got a redesign qustion.

    im redesigning my database ( u know..... deleteing some nonessential tables , adding some columns , more constraints )

    the thing is- that DB is still in use.

    so i want to clone this DB and make the changes in the clone ,

    then after ive checked everything .... slowly transfer all application to the replicated DB.

    so whats the best way to copy a DB - ive seen a lot of options...

    and does any 1 have a better idea how to redesign the DB with out interrupting in all days work

  • October 23, 2005 at 5:59 pm

    #599403

    This is what I would do...

    Take a full backup of the existing database - create a brand new database - restore backup to new database. Make modifications to "copy database" and test changes!







    **ASCII stupid question, get a stupid ANSI !!!**

  • October 24, 2005 at 12:10 am

    #599422

    thx

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply