Is there a tool for translating SQL scripts ?
Thread poster: RWSTranslation

RWSTranslation
Germany
Local time: 02:56
Member (2007)
German to English
+ ...
Jan 24, 2003

Hello



is there a tool for translating SQL Skripts ?



Thanks



Hans


Direct link Reply with quote
 

Boyan Kostadinov  Identity Verified
Bulgarian to English
+ ...
Translating SQL scritps to what? Jan 24, 2003

What would you like to translate SQL to?



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


Direct link Reply with quote
 

RWSTranslation
Germany
Local time: 02:56
Member (2007)
German to English
+ ...
TOPIC STARTER
Example Jan 24, 2003

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


Direct link Reply with quote
 

RWSTranslation
Germany
Local time: 02:56
Member (2007)
German to English
+ ...
TOPIC STARTER
Example 2 Jan 24, 2003

Hello,



I think it is clear, that my example is only one line of thousands.



Hans


Direct link Reply with quote
 
Sonja Tomaskovic  Identity Verified
Germany
Local time: 02:56
English to German
+ ...
Changing the whole script? Jan 24, 2003

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


Direct link Reply with quote
 

Rick Henry  Identity Verified
United States
Local time: 19:56
Italian to English
+ ...
This really has to do with programming, not localization, per se... Jan 24, 2003

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]

Direct link Reply with quote
 

RWSTranslation
Germany
Local time: 02:56
Member (2007)
German to English
+ ...
TOPIC STARTER
SQL insert Jan 24, 2003

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


Direct link Reply with quote
 

Rick Henry  Identity Verified
United States
Local time: 19:56
Italian to English
+ ...
You can always find out the structure... Jan 24, 2003

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



Direct link Reply with quote
 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Is there a tool for translating SQL scripts ?

Advanced search






SDL MultiTerm 2017
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2017 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2017 you can automatically create term lists from your existing documentation to save time.

More info »
Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search