I have a .db file, with a bunch of tables and data (and a few one to many relationships), instead of rewriting everything, is there a way for me to just upload this database directly to Azure SQL?
Asked
Active
Viewed 295 times
1
-
what have you tried now? Or did you upload the .db file to Azure SQL successfully before? – Leon Yue Jul 07 '20 at 09:24
-
Just as I know, .db files are standalone files, there isn't a way which can upload this database directly to Azure SQL. Maybe you could reference this link https://stackoverflow.com/questions/24962255/how-can-i-make-use-of-a-db-file-in-sql-server-2008 to get some workarounds. – Leon Yue Jul 07 '20 at 09:33
1 Answers
0
My suggestion is to install SQL Server Developer Edition on your laptop or local computer and import those database files to that SQL instance as explained here, if they are Dbase files.
Once you have imported the .dbf files to the local SQL Server instance, use SQL Server Management Studio to deploy the database to Azure as shown here and here, or you can use Data Migration Assistant to migrate to Azure as explained here.
Alberto Morillo
- 13,893
- 2
- 24
- 30