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. 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. Regards Muthu On Mon, Nov 30, 2020 at 11:02 AM Pavel Stehule <pavel.steh...@gmail.com> wrote: > > > po 30. 11. 2020 v 6:12 odesÃlatel Muthukumar.GK <muthanku...@gmail.com> > 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. >> >
