Hi,
We have a split database. I used the migration tooling to migrate tables to an Azure database. All tables have been renamed from TABLENAME to DBO.TABLENAME because of the way to use SQL in a proper way.
My frontend however is using the plain tablenames. What's the best way to go: rename all references in SQLscripts/VBA code etc. to the new tablenames? Or (manually) change the linked tablename to TABLENAME where it references DBO.TABLENAME at SQL side. The disadvantage of this is that I can no longer easily switch to a new dataset because external and internal tablenames are different.
Any suggestions?
We have a split database. I used the migration tooling to migrate tables to an Azure database. All tables have been renamed from TABLENAME to DBO.TABLENAME because of the way to use SQL in a proper way.
My frontend however is using the plain tablenames. What's the best way to go: rename all references in SQLscripts/VBA code etc. to the new tablenames? Or (manually) change the linked tablename to TABLENAME where it references DBO.TABLENAME at SQL side. The disadvantage of this is that I can no longer easily switch to a new dataset because external and internal tablenames are different.
Any suggestions?