September 29, 2003 at 4:19 am
We have a large website of around 100,000 users. The site is in english.
We are trying to 1 more language to the site, ie: users can browse the website either in English or Arabic.
So, in our development enviroment (Our local mirror of the database which we work on), we added
extra fields in each table carrying the arabic data.
The problem now is how to export this new database structure to the host so that it can be available online
with no data loss keeping in mind that the 2 databases (Our local development database & the other online one) are inconsistent.
Do we have to re-do all those changes manually once again @ the online database, or is there a way to preserve the
online data & @ the same time have the new tables structure.
September 29, 2003 at 5:37 am
There are tools out there to help with this task. SQLCompare is probably the most widely used one. It can do structure and data comparisons to help you sync the two databases up. You may also check the scripts section of this site I think there are a couple of them that will do schema updates.
Wes
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply