Import data from Firebase into my database

Question

I've read a few articles which suggest I could import data from Firebase into my own SQL database.

1. How do I do that?
2. Is this a one task or could I schedule it so it's automatically importing any new records that are added?
3. How could the database be created or do I create it?
4. If I create the database how do I design the schema?

Ideally the data would be one way, so once imported into my database then the source can be deleted.

Appreciate if anyone could put me on the right path

Thanks

Answer 1

Hi @Mr Edge

A similar question was asked on Stackoverflow at https://stackoverflow.com/questions/69108106/best-way-to-export-firebase-into-azure-sql

The easiest way is to use "WAY 3" (which states that you need no coding experience) suggested by SwethaKandikonda which is a 3rd party tool called Improvado found here.

-------------------------------------------

If this is helpful please accept answer.

Answer 2

How could the database be created or do I create it?

As long as you don't find a migration tool, you have to do it yourself.

If I create the database how do I design the schema?

Depends on what for a schema you want to get; we can't say.
The common and easiest way to create the exact same schema as in your source database, then you can copy the data over 1:1.

I could import data from Firebase into my own SQL database.

Once the destination database is create, you can use a ETL tool like SQL Server Import/Export Wizard or SSIS (Integration Servcies).

Answer 3

Hi @Mr Edge ,
Maybe you can try this solution:
Step 1:Exporting your Firebase data into a JSON File.
Step 2:Converting the JSON file into a CSV file.
Step 3:Importing the CSV File into your SQL Server Database.
Here is the reference link:https://hevodata.com/learn/firebase-sql-server-integration/#hevo

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment"