SQL 2022 upgrade issues

  • We're about to upgrade our SQL 2017 Standard to 2022 standard.  We have 1 customer who takes a backup and restores it to their 2019 instance (so they can run Power BI reports).  We cannot postpone it, and they have asked if we could consider a BACPAC from our new 2022 to their 2019 version.  The database size is 50GB.

    If their idea feasible or is there a better approach (other than them upgrading to 2022 as well)?

  • BACPAC is all you can do, and then only if you haven't used any 2002 only features in code.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply