Re: Migrating database(s) from Sybase ASE 15.7 to PostgreSQL 10.6 on Linux

2019-05-03 Thread pabloa98
If you could use foreign data wrapper to connect https://github.com/tds-fdw/tds_fdw then you can skip the migration back and for to CSV. You could even do partial migrations if needed (it could impact some queries' speed though). Pablo On Fri, May 3, 2019 at 6:37 AM Adrian Klaver wrote: > On

Re: Migrating database(s) from Sybase ASE 15.7 to PostgreSQL 10.6 on Linux

2019-05-03 Thread Adrian Klaver
On 5/3/19 4:56 AM, Matthias Apitz wrote: Hello, We're investigating the migration of our LMS (Library Managment System) from Sybase ASE 15.7 to PostgreSQL 10.6. The used database in field have around 400 columns, some of them are also containing BLOB (bytea) data. The DB size vary upto 20

Re: Migrating database(s) from Sybase ASE 15.7 to PostgreSQL 10.6 on Linux

2019-05-03 Thread Adrian Klaver
On 5/3/19 6:09 AM, Matthias Apitz wrote: El día Friday, May 03, 2019 a las 07:38:23AM -0500, Ron escribió: On 5/3/19 6:56 AM, Matthias Apitz wrote: Hello, We're investigating the migration of our LMS (Library Managment System) >from Sybase ASE 15.7 to PostgreSQL 10.6. The used database in

Re: Migrating database(s) from Sybase ASE 15.7 to PostgreSQL 10.6 on Linux

2019-05-03 Thread Matthias Apitz
El día Friday, May 03, 2019 a las 07:38:23AM -0500, Ron escribió: > On 5/3/19 6:56 AM, Matthias Apitz wrote: > >Hello, > > > >We're investigating the migration of our LMS (Library Managment System) > >from Sybase ASE 15.7 to PostgreSQL 10.6. The used database in field have > >around 400 columns,

Re: Migrating database(s) from Sybase ASE 15.7 to PostgreSQL 10.6 on Linux

2019-05-03 Thread Christoph Moench-Tegeder
## Matthias Apitz (g...@unixarea.de): > Re/ the migration of the data itself, are there any use case studies > which could we keep in mind? https://wiki.postgresql.org/images/e/e7/Pgconfeu_2013_-_Jens_Wilke_-_Sybase_to_PostgreSQL.pdf Regards, Christoph -- Spare Space

Re: Migrating database(s) from Sybase ASE 15.7 to PostgreSQL 10.6 on Linux

2019-05-03 Thread Ron
On 5/3/19 6:56 AM, Matthias Apitz wrote: Hello, We're investigating the migration of our LMS (Library Managment System) from Sybase ASE 15.7 to PostgreSQL 10.6. The used database in field have around 400 columns, some of them are also containing BLOB (bytea) data. The DB size vary upto 20