Fully qualified or synonym for table in another database, cloud migration plan

0 votes

2 answers

189 views

                          Scenario: 
In SQL Server on-prem and plan to go the cloud in a year or two.

I am writing a stored procedure in database A and I need to access a table from database B.

Is it a best practice to create a synonym that points to the table in database B or just fully qualify the table in the package?

Asked by aimyee (9 rep)

Jun 23, 2022, 03:41 AM
Last activity: Jun 23, 2022, 04:58 PM

Fully qualified or synonym for table in another database, cloud migration plan

Related Questions