po 30. 11. 2020 v 7:06 odesÃlatel Muthukumar.GK <muthanku...@gmail.com> 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.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. >>> >>
