Can I export data from .sdf file into sql database
Hey guys,
I already created umbraco8 setup it's work fine form me on local machine but when this setup i upload on server then it's work fine for some time after then it's not working. So i want to export my data from .sdf file to database.
I think this problem become due to database.
So can i export data from .sdf file to database because my setup already created.
Thanks, Shaishav It's created a database but I have another one problem, how to use the same database on the place of .sdf file in my existed Umbraco project.
Can I export data from .sdf file into sql database
Hey guys, I already created umbraco8 setup it's work fine form me on local machine but when this setup i upload on server then it's work fine for some time after then it's not working. So i want to export my data from .sdf file to database. I think this problem become due to database. So can i export data from .sdf file to database because my setup already created.
Hi Rakesh,
Yes you can export sdf to sql script and then run the sql script on new sql database.
Below link shows the step-by-step guide to achieve it. https://blog.nicolaayan.com/2018/02/how-to-migrate-sdf-database-to-sql-server/
Regards, Shaishav
Thanks, Shaishav It's created a database but I have another one problem, how to use the same database on the place of .sdf file in my existed Umbraco project.
Hi,
You can replace existing connection string with below and provide your database details
Regards,
Shaishav
is working on a reply...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.