0

Source: SQL Server 2008 R2 Destination: Azure SQL Database in an elastic pool

I am migrating multiple databases from source to destination using offline DMS. While migrating these databases some stored procedures are giving errors because of three-part and four-part entries in the stored procedure. for this, I am using external tables to convert it into two-part. but some stored procedures are used for DML commands like insert and update. I want to know how I can convert this DML commands stored procedure in elastic query.

shubhi jain
  • 29
  • 3
  • See [sp_execute _remote](https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-execute-remote-azure-sql-database) for invoking a stored procedure on external tables – KarthikBhyresh-MT Sep 28 '21 at 04:14

1 Answers1

0

As a limitation mentioned in this doc, Migrating to a DB in elastic pool directly isn't supported. But you can import data into a single database and then move the database to an elastic pool. Once you have it in same Logical Server. Move the DB under Elastic Pool.

Refer similar ask here or the official MS doc to do this using the Portal

Instead you can also initiate replication from a snapshot or through BULK Load.

KarthikBhyresh-MT
  • 4,560
  • 2
  • 5
  • 12