ProZ.com Translation Forums

Is there a tool for translating SQL scripts ? | You can always find out the structure...

Rick Henry — Fri, 24 Jan 2003 22:20:00 +0000

Forum: Localization
Topic: Is there a tool for translating SQL scripts ?
Poster: Rick Henry
Post title: You can always find out the structure...

There\'s always a way to get database/table information and structure from each DB\'s respective command prompt. Oracle uses DESC (tablename), PostgreSQL uses \\D (tablename) and MySQL uses DESCRIBE (tablename). Those are just exmaples of three common DBs out there.

From your SQL example, you must know, at least partially, what your table structure is. Otherwise, how would you know what to call each field?

Quote:

On 2003-01-24 17:09, DSC wrote:

Hello,

if you take a look on the skript line, you can see that we have a \"insert\" query, which mean, that all values will be inserted in a database.

Of course it will be better to extract the whole datebase entries and translate them, but at the moment we don\'t know the structure of the database. It\'s also not clear, if there other entries in the database.

At the moment we checkl these points, but possible we have to translate the values of these sql statements.

Thanks

Hans

Is there a tool for translating SQL scripts ? | SQL insert

RWSTranslati (X) — Fri, 24 Jan 2003 17:09:00 +0000

Forum: Localization
Topic: Is there a tool for translating SQL scripts ?
Poster: RWSTranslati (X)
Post title: SQL insert

Hello,

if you take a look on the skript line, you can see that we have a \"insert\" query, which mean, that all values will be inserted in a database.

Of course it will be better to extract the whole datebase entries and translate them, but at the moment we don\'t know the structure of the database. It\'s also not clear, if there other entries in the database.

At the moment we checkl these points, but possible we have to translate the values of these sql statements.

Thanks

Hans

Is there a tool for translating SQL scripts ? | This really has to do with programming, not localization, per se...

Rick Henry — Fri, 24 Jan 2003 16:35:00 +0000

Forum: Localization
Topic: Is there a tool for translating SQL scripts ?
Poster: Rick Henry
Post title: This really has to do with programming, not localization, per se...

Depending on what kind of database you\'re using, you may be able to write (or have someone write) a procedure (stored procedure in oracle) that basically looks up the german value and places the english value in it\'s proper field using some kind of lookup table. You\'re not changing the SQL in any way (that I can tell)... just substituting values. In any case, I don\'t think there\'s any getting around manual entry of some sort for the corresponding values. It\'s either going to be in the code itself or in a lookup table.

R.

==

Quote:

On 2003-01-24 14:56, DSC wrote:

Hello,

ok, maybe an example will help:

insert into wass_schaltantrieb_absp(code, description_g, description_f, description_i, description_e, labeltext_g, labeltext_f, labeltext_i, labeltext_e, idx) values(0, \'unbekannt\', \'inconnu\', \'sconosciuto\', \'\', \'U\', \'I\', \'\', \'\', 1);

We want to translate vales of description_g and labeltext_g into english ad place them into the value field of decription_e and labeltext_e.

Thanks

Hans

[ This Message was edited by:on2003-01-24 16:57]

Is there a tool for translating SQL scripts ? | Changing the whole script?

Sonja Tomaskovic (X) — Fri, 24 Jan 2003 16:10:00 +0000

Forum: Localization
Topic: Is there a tool for translating SQL scripts ?
Poster: Sonja Tomaskovic (X)
Post title: Changing the whole script?

Hi Hans,

what I do not understand fully is, why does your client want to change SQL queries like the one that you posted?

Does he want you to translate the whole database into English (i.e. the names of the rows of the database tables?).

It does not make any sense at all to change queries that work with the same database.

Otherwise, if he indeed wants to change the whole database, then you probably have to edit all the queries yourself. As far as I know there is no specific tool that can edit SQL. (Mainly, because there is no sense in editing SQL queries for the above reasons. As long as the row names do not change, the query doesn\'t need to be translated.)

Kind regards,

Sonja

Is there a tool for translating SQL scripts ? | Example

RWSTranslati (X) — Fri, 24 Jan 2003 14:56:00 +0000

Forum: Localization
Topic: Is there a tool for translating SQL scripts ?
Poster: RWSTranslati (X)
Post title: Example

Hello,

ok, maybe an example will help:

insert into wass_schaltantrieb_absp(code, description_g, description_f, description_i, description_e, labeltext_g, labeltext_f, labeltext_i, labeltext_e, idx) values(0, \'unbekannt\', \'inconnu\', \'sconosciuto\', \'\', \'U\', \'I\', \'\', \'\', 1);

We want to translate vales of description_g and labeltext_g into english ad place them into the value field of decription_e and labeltext_e.

Thanks

Hans

Is there a tool for translating SQL scripts ? | Translating SQL scritps to what?

Boyan Kostadinov — Fri, 24 Jan 2003 14:29:00 +0000

Forum: Localization
Topic: Is there a tool for translating SQL scripts ?
Poster: Boyan Kostadinov
Post title: Translating SQL scritps to what?

What would you like to translate SQL to?

Can you please give a more specific information on your question?

Is there a tool for translating SQL scripts ?

RWSTranslati (X) — Fri, 24 Jan 2003 00:39:00 +0000

Forum: Localization
Topic: Is there a tool for translating SQL scripts ?
Poster: RWSTranslati (X)

Hello

is there a tool for translating SQL Skripts ?

Thanks

Hans