Hi,

Question: Can I import Sage X3 folder which was taken from a server using newer version of SQL Server to an older version SQL Server?

Second question: Can I import Sage X3 folder which was taken from Oracle database to a SQL Server database?

Context:

I have a client requesting to prove, in my local lab server, that Sage X3 v12p34 has no issue with their data and customization.

However, the Sage X3 local lab server is using licensed SQL Server 2016 Standard instance and my client is using licensed SQL Server 2022 Enterprise instance.

As far as I know, Microsoft does not allow SQL Server database recovery from higher version to lower version without using a certain tool I am not familiar with: https://www.reddit.com/r/SQLServer/comments/zt2tqd/sql_2022_standard_downgrade_to_sql_standard_2019/

The tool in question: https://learn.microsoft.com/en-us/sql/relational-databases/data-tier-applications/data-tier-applications?view=sql-server-ver16