May 31, 2006 at 5:51 am
Dear Folks,
Hai to all. i have a big deal infront me now, can you please look in to this and give me your suggestions
I have an SQL server Database (First DB) with tracking of bugs in English Language, and i have another SQL server database (Second DB) with tracking of bugs in Spanish language. But important thing here is both the datastructres (table names and fields) are different.
Now i need to migrate the two SQL severs with the current updates in both severs. For example if there s any changes made in first DB, needs to reflect in the second DB and vice versa.
Help in the process, how i need to follow...
Thanks in Advance.
AnanthaM
May 31, 2006 at 7:08 am
Without more information, it's going to be hard to help you with this, but I would guess from your post that you have two tables, one in English, the other in Spanish, with some sort of key that identifies the bug, as well as the text description of the bug in the respective language.
If that's the case, why not change the structure so that you have a single table, with the key, as well as two additional columns, one for the bug in English, one in Spanish. It would make maintaining the table a breeze, as the two sets of descriptions would always be in synch.
Am I missing something about your problem?
May 31, 2006 at 7:19 am
Thank you Mr. David
Your solutions is good, my problem is i need to sync both the databases and in the II phase i need to translate the languages one in another and shows in reports
here you missed the attachments parts, each bug may or may not have attachments explining the detail bug description.
could you plea help me in this issue..
Thanks
Anantha
May 31, 2006 at 7:32 am
To synch the databases, you'll want to be able to see what bugs are in one but not the other. Something like:
SELECT
eng.BugNumber
,eng.BugDescription
,spa.BugDescription
FROM
EnglishBugTable AS eng
FULL OUTER JOIN SpanishBugTable as spa ON
eng.BugNumber = spa.BugNumber
which will show you which bugs have just English or Spanish translations, but not both.
By the way, even dealing with attachments could be handled with a consolidated table, so don't rule out the option.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply