Thanx, I really think thats the best way to do the job. What do u think of detach & attach and then restore the tlogs, is that similar to backup...

I am using SQL Server 2000.

By "Changing the structure", I mean that we are adding new columns to each table. These new columns will carry the arabic data.

By Registered users I mean web users not Server logins or user accounts. I mean that the database has many tables of 100,000 each.

Detaching & attaching the database would be...

That will fine, but after creating the new structure how can I ensure data is the same on both sides? How can I export the new arabic data in the...