| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | "Muthukumar(dot)GK" <muthankumar(at)gmail(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Migration from SQL Server to PostgeSQL |
| Date: | 2020-11-30 05:31:34 |
| Message-ID: | CAFj8pRAEmgdjxbErBEp8u3J1nKQ_NCs-gMLOvHSSPPhdfy6Axw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
po 30. 11. 2020 v 6:12 odesílatel Muthukumar.GK <muthankumar(at)gmail(dot)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.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Muthukumar.GK | 2020-11-30 06:05:49 | Re: Migration from SQL Server to PostgeSQL |
| Previous Message | Muthukumar.GK | 2020-11-30 05:11:44 | Migration from SQL Server to PostgeSQL |