Updating the database structure | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Updating the database structure

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.

Kindly refrain posting multiple(duplicate) posts…. thread locked.
Continue discussion athttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=1792 _________
Satya SKJ