export from postgres to oracle

Classic Servoy
1

Hi, i don’t know if is the right place to post this question, anyway, i want to migrate svy_framework from postgres to Oracle 11g, and i don’t know how to do this?
Anyone can help me, please?

Thanks
Bye

2

Hi Poyel,

What I think might be the easiest is to make a servoy export on postgress with data. Then change you db connection to Oracle and make a import with data. The import will then generate the tables and populate the data.

Regards Sanneke

3

Hi sanneke, thanks for the quick reply.

I think that your solution is great, but more complicated for me because the project is shared on svn server. I was hoping in a export/import operation.

You think that is possible? And if yes, how can i do this?

Thanks

4

You can still do the export/import if you have SVN. After the import its maybe easiest to delete all the solutions from you local workspace and check them out again from the SVN.

Regards Sanneke

5

But if i perform an export with data, Servoy export the data of all active connection, and not only of the connection svy_framework, right?

6

Yes that is true. But it is called sample data for a reason, by import it will only import data in empty tables.

7

Fantastic!!! i will try to export with sample data very soon.

Thanks Sanneke.