sackling Posted December 8, 2010 Share Posted December 8, 2010 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.. Link to comment Share on other sites More sharing options...
Hotclutch Posted December 8, 2010 Share Posted December 8, 2010 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. Link to comment Share on other sites More sharing options...
sackling Posted December 14, 2010 Author Share Posted December 14, 2010 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. Link to comment Share on other sites More sharing options...
Guest Posted December 14, 2010 Share Posted December 14, 2010 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.