Substitute for table variable and data migration approach

[Avadhut Narayan Joshi <AJoshi7@xxxxxxxxxxxxxxxx>]

Hello Geeks ,

 

As in SQL Server we have table variable and it can be passed as a parameter to a stored procedure . Which is the best alternative for it in PostgreSQL ?

 

Also any advice / suggestions on tool which can be used to migrate data from SQL Server / Oracle to PostgreSQL ?

Solution should be

1. Performant on large DB size > 500 GB
2. Should have re-start logic
3. Should have error logging capabilities
4. Easy to deploy/use in Prod environment

 

Please give Suggestions / recommendations .

 

Regards

Avadhut

 

Sent from Mail for Windows 10