I have SQL server 2016 on server A.
I want to migrate to SQL Server 2019 server B. I have installed the SQL server which auto creates the system dbs (master, msdb, model). D drive is for data files and E drive is for log files.
Source and Target sql servers share the same SAN infrastructure.
Now I want to re-point the LUNs from the source server to this server (for D and E drives) to migrate the databases. Upon doing this, the D and E drives on target sql server will be as they were in the source sql server.
- Now when I attach the system and user dbs, will the sql server 2019 still work with the system dbs from an older version?
- Or is this re-pointing LUN approach only suitable for migration with the same sql version?
- Or is this re-pointing LUN approach only suitable for migration of user databases?