Can I port my SQL Server Express DB to SQL Server and have it hosted by Azure?

Question

This is related to, or similar to, my question here.

I plan on accessing my database from a website, and from at least one app that mimics the web site's functionality. I say "at least one" because I may also create a macOS version of the app, and perhaps an Android version.

I thought of having app users download the entire database to their device/machine (for better performance), but am leaning towards hosting the DB in one place for users of the web site and the app[s] to access.

I can host a DB on Azure; can I upload my SQL Server Express DB files for them to be hosted, or do I need to create a standard SQL Server database on Azure and then pump the data from the existing (SQL Server Express) database into the newly created standard SQL Server database?

Answer 1

Hi @clay shannon ,

Please check if you can do the following steps:
1.Create a BACPAC file: If you can create the BACPAC file from your database that means your database can be migrated to Azure SQL Database.
2.Use a script: Generate a schema of the on-premises databases and create the same in the Azure SQL environment.

There are several ways to migrate the data. The following are some of the methods that can be used for data migration:
1.Create BACPAC files and export them
2.Use SQL Server Management Studio; generate scripts and use the import/export data methods
3.Use the Data Migration Assistant Wizard
4.Leverage Transactional Replication to port the data over to the cloud
5.Use PowerShell and SQLPackage.exe, an SSDT tool

Please refer to Migrate on-premises SQL Server database to Azure SQL Database.

Best Regards,
Mona

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.