I am working actively at the redesign of a system made of a lot of files and tables. Among other things that need to get changed, I have table and field names with accented characters and or characters that should not be used such as "/", "+", etc. At this stage, I am testing redesign tasks such as these that will be applied to the real files.
Since renaming tables and fields will be a large chore, I don't want to do that manually, too prone to errors. I know that using scripts, I can't changed table and field names. But looks like it's possible through ODBC and JDBC ( I have yet to read the documentation ). So I would like to get your inputs - my guess is that fmpdude will add its 2 cents in 3, 2, 1 . Then my questions:
- Is JDBC faster than ODBC - that's my guess after reading some posts here and there ?
- If the answer to question 1 is JDBC is faster, then I am not knowledgeable of Java, so I was wondering if I may use Pyhton instead ? Looks like Python can use JDBC to connect to a database.
- Are there any issue I may run into changing the schema that way ?
- Any other comments are welcome
Thanks to all