Just some feedback.
I proceeded this way, may be you have a brighter idea.
I stored all the query.Name and query.SQL in a Table y_Queries (QueryName(txt),QuerySQL(memo)), copied the Table into the SQL Linked BE, deleted all the queries there and restored them from y_Queries.
I had some problems with this procedure, because the query equations contain alphanumerics not allowed as text in tables. I had to substitute these characters by others before saving, and then back before restoring.
Finally, opening the restored queries one by one a got a quite a bit with errors - I still have to find out what is going on – but the rest worked fine with restored joins. Alleluia! Some of them are very slow though. I will have to go through all of them to see if I can achieve some better design.
Thanks again for your help.
I proceeded this way, may be you have a brighter idea.
I stored all the query.Name and query.SQL in a Table y_Queries (QueryName(txt),QuerySQL(memo)), copied the Table into the SQL Linked BE, deleted all the queries there and restored them from y_Queries.
I had some problems with this procedure, because the query equations contain alphanumerics not allowed as text in tables. I had to substitute these characters by others before saving, and then back before restoring.
Finally, opening the restored queries one by one a got a quite a bit with errors - I still have to find out what is going on – but the rest worked fine with restored joins. Alleluia! Some of them are very slow though. I will have to go through all of them to see if I can achieve some better design.
Thanks again for your help.