Jump to content

Archived

This topic is now archived and is closed to further replies.

sackling

database switchover after update help needed

Recommended Posts

I am on the verge of completing a complete overhaul on my site.

 

There have been many database updates to support various new features I have implemented onto the new site.

 

My old site however has been active this entire time, which means there are new customers and new orders (I think that's it) that are new from the database I have been working on.

 

What is the best way to merge these 2 databases? Presumably Just update the new database with the customer table, order table from the old database?

 

Is there a better procedure that most people use in the future. Obviously both databases will be excessively backed up..

Share this post


Link to post
Share on other sites

I am on the verge of completing a complete overhaul on my site.

 

There have been many database updates to support various new features I have implemented onto the new site.

 

My old site however has been active this entire time, which means there are new customers and new orders (I think that's it) that are new from the database I have been working on.

 

What is the best way to merge these 2 databases? Presumably Just update the new database with the customer table, order table from the old database?

 

Is there a better procedure that most people use in the future. Obviously both databases will be excessively backed up..

 

Why not use your existing database as is with your new file set? You don't say if the actual structure is different between old and new.

Share this post


Link to post
Share on other sites

Why not use your existing database as is with your new file set? You don't say if the actual structure is different between old and new.

 

There have been some newly added tables to the new database.

Share this post


Link to post
Share on other sites

Robert,

 

You can import the necessary data into the new tables. You may need to alter the data some, but you should have little trouble.

 

 

 

Chris


:|: Was this post helpful ? Click the LIKE THIS button :|:

 

See my Profile to learn more about add ons, templates, support plans and custom coding (click here)

Share this post


Link to post
Share on other sites

×