Firestore无SQL数据库导入选项，咨询Beta阶段后是否会开放该功能
Great question! You’re absolutely right that right now, Firestore doesn’t offer a built-in option to directly import an SQL database—unlike Realtime Database, which does have this functionality.
First, a quick note: Firestore exited its beta phase back in 2019, so we’re looking at its current and future roadmap rather than beta-specific plans. As of now, Google hasn’t made any public, concrete commitments about adding a native SQL import tool to Firestore. That said, the Firebase team regularly prioritizes features based on user feedback, and this is a request that pops up frequently in developer communities.
In the meantime, here are practical workarounds to get your SQL data into Firestore:
- Export SQL to JSON/CSV first: Most SQL databases let you export data to JSON or CSV formats. Once you have that, you can use the Firebase CLI’s
firebase firestore:importcommand to upload the formatted data. Just be sure to adjust your JSON structure to fit Firestore’s collection/document model—you might need to tweak relational data to work with Firestore’s non-relational setup. - Build a custom migration script: For complex relational data (like tables with joins), write a simple script in a language you’re comfortable with (Node.js, Python, etc.). The script can connect to your SQL database, fetch records, transform them into Firestore-compatible documents, and use the Firestore SDK to batch-write the data. This gives you full control over how you map relational relationships to Firestore’s structure.
- Leverage ETL tools: Some third-party ETL (Extract, Transform, Load) tools support both SQL databases and Firestore, handling the data transfer and transformation for you without needing to write custom code.
If you want to push for this native feature, I’d suggest submitting feedback through the Firebase console’s feedback tool or the Firebase GitHub repository—user input plays a big role in the team’s feature prioritization.
内容的提问来源于stack exchange，提问作者android51130
