Restore-ExternalDatabasesForXMC.sql

-- We attach two legacy databases into a locally-run XM Cloud instance: "CoreOld" and "Old" (which is master)

EXEC sys.sp_configure N'contained database authentication', N'1'
go
exec ('RECONFIGURE WITH OVERRIDE')
go

CREATE DATABASE [Sitecore.Old]
  ON (FILENAME = 'C:\data\Sitecore.Old_Primary.mdf'),
     (FILENAME = 'C:\data\Sitecore.Old_Primary.ldf')
  FOR ATTACH;

CREATE DATABASE [Sitecore.CoreOld]
  ON (FILENAME = 'C:\data\Sitecore.CoreOld_Primary.mdf'),
     (FILENAME = 'C:\data\Sitecore.CoreOld_Primary.ldf')
  FOR ATTACH;