I have a set of databases that is from SQLServer 2017 and I am trying to import the master and core databases into a SQLServer 2014. Also, it is on a Sitecore 8.2 U7 for both instances.
Not sure if its valuable to mention, but I also have Web Forms for Marketers 8.2 rev. 180329 and Sitecore.PowerShell.Extensions-5.1 modules.
For the master database, I got to a point where I have just updated the connectionString in my Sitecore instance using SQLServer 2014 to point to the instance that has the reference from SQL Server 2017, and then published the site from master to web. Then export/restore web into master. Worked out well... But for the core I can't.
So far, I have tried these :
- Create a package from Core Database using Package
- Somehow, the installation keeps failing.
- Script the database using this reference : https://solutioncenter.apexsql.com/restore-sql-server-database-backup-to-older-version-of-sql-server/
- The output script is kind of redundant and not good. Using wrong database name and also try to re-create a whole bunch of stuff that is already there.
So I wonder, have any of you faced similar issue, if so, what path/strategy have you chosen ?