Link to home
Start Free TrialLog in
Avatar of chokka
chokkaFlag for United States of America

asked on

How to export SQL to firebase ?

I am working on Xamarin App using SQL Database in the Server. However due to pricing  issues with Azure or Amazon, i have decided to move to firebase ?

How should i migrate the SQL database to firebase ?
Avatar of gheist
gheist
Flag of Belgium image

Firebase is not a SQL database. More viable would be moving to mysql or postgresql which will chop pricing to just CPU/RAM/Storage and no licencing cost.
Avatar of chokka

ASKER

Thank you @ghesit .. assuming that migrating to mysql .. will it cost any money on moving to any cloud based services such as Amazon ?Alternatively, if there is no cost involved options .. please advise me on that .. it need not to be cloud based service..
Avatar of EugeneZ
just an idea for free solution that needs to be tested vs what you have:

if you have Azure Sql server 2016 and it has a small DB (<10GB) that you need to move to your local sql server

1st
you need to have installed free Sql server 2016 express edition
https://www.microsoft.com/en-us/sql-server/sql-server-editions-express

or ~$70 Sql server dev edition (it has all sql server features) if you use it for development -
or free if you are Visual Studio Dev Essentials member
https://blogs.technet.microsoft.com/dataplatforminsider/2016/03/31/microsoft-sql-server-developer-edition-is-now-free/
-or use "normal" standard /enterprise sql
----
after you have sql server installed and have right on azure and destination server
you need to set your P{C\Server ) trust on Azure

you can try to follow this "step-by-step" instruction

Move SQL Azure Database to Local SQL Server
http://www.magnetismsolutions.com/blog/dinesh's-blog/2015/04/13/move-sql-azure-database-to-local-sql-server
Avatar of chokka

ASKER

@Eugenez , I have already explored SQL DB pricing issues .. Now i am considering moving to Google SQL .. which is MySQL. Unless you can suggest me something which has no costing involved ..
ASKER CERTIFIED SOLUTION
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of chokka

ASKER

@Eugenz thank you .. this helps !! Are you saying that Amazon RDS is free for SQL ??
Avatar of chokka

ASKER

Thanks
Anybody has a solution about how to migrate from a MS-SQL DB to GCP Firebase?