0

I have a SQL Express 2014 instance on a server with 1 database that has 1 table. I would like to move that database to an existing SQL Server 2019 Standard instance that is on a different server. The windows server version of the Express instance is 2012R2, the windows server version of the SQL Standard version is 2019, both are 64-bit.

I'm a SQL newbie. Can someone point me to a how-to guide that tells me how to move that sql express database? All I've been able to find are instructions for upgrading the SQL server, not moving a database to an existing server.

3
  • Any reason not to just manually recreate the database and table on the Standard instance, and script out the data or use a data migration tool?...how much data is there (by size and / or row count)?
    – J.D.
    Jan 3, 2023 at 15:18
  • I was definitely considering doing that but didn't know if it would cause a problem going from one version to another. There are only 40,575 rows in the table. Jan 3, 2023 at 16:28
  • Can I just script out the database and create a new one in the standard instance using that script? Jan 3, 2023 at 16:29

1 Answer 1

1

Why don't you just do a backup of the express database and restore it to the standard instance?

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.