RE: Substitute for table variable and data migration approach

Поиск
Список
Период
Сортировка
От Avadhut Narayan Joshi
Тема RE: Substitute for table variable and data migration approach
Дата
Msg-id PH0PR18MB4608A2856F03A3AE38A428A39C1C9@PH0PR18MB4608.namprd18.prod.outlook.com
обсуждение исходный текст
Ответ на Substitute for table variable and data migration approach  (Avadhut Narayan Joshi <AJoshi7@sensiaglobal.com>)
Список pgsql-admin

Hello Geeks ,

 

Any suggestions / recommendations for below questions ?

 

Regards

Avadhut

 

Sent from Mail for Windows 10

 

From: Avadhut Narayan Joshi
Sent: 02 July 2021 19:51
To: pgsql-admin@lists.postgresql.org
Subject: Substitute for table variable and data migration approach

 

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

 

 

В списке pgsql-admin по дате отправления:

Предыдущее
От: Rui DeSousa
Дата:
Сообщение: Re: The trap when using pg_dumpall
Следующее
От: Yambu
Дата:
Сообщение: logical replication in high volume transactions