Search Postgresql Archives

Re: Migration from SQL Server to PostgeSQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





po 30. 11. 2020 v 7:06 odesílatel Muthukumar.GK <muthankumar@xxxxxxxxx> napsal:
Hi Pavel,

Kindly let me know the following functionality can be possible in postgresql. If possible,provide me with a sample program.

1. Call the procedure from/inside another procedure  and insert the result set into Temp Table.

it is possible

2. Creating Dynamic procedure in postgresql. because We have dynamic procedure in SQL server, On execution of this  Procedure, another two procedures will be Created dynamically.

I don't know what dynamic procedure is.




Regards
Muthu

On Mon, Nov 30, 2020 at 11:02 AM Pavel Stehule <pavel.stehule@xxxxxxxxx> wrote:


po 30. 11. 2020 v 6:12 odesílatel Muthukumar.GK <muthankumar@xxxxxxxxx> napsal:
HiTeam,

We need to migrate tables,Records,Procedure and function from SQL server to Postgresql. Kindly let me know, Is there any  tool or easiest way  available to migrate from SQL Server to Postgresql. Please let me know if there are any limitations in postgresql compared to SQL server.

The migration from MSSQL can be difficult, and needs a lot of manual work. The concept of procedures is very different. In MSSQL is natural returning multirecordset from procedures. This is not possible in Postgres, where design of procedures (or all design) is similar to Oracle. It is possible. I know some customers that did successful migrations from Sybase to Postgres (Sybase had the same roots like MSSQL).

Regards

Pavel


Regards
Muthu.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux