Last post Jan 17, 2013 12:33 AM by Abhishek Luv
Jan 17, 2013 12:14 AM|prdo|LINK
I have a cloud database,and it only can be connected from the special VPS. My site have a .sdf data file on local machine,How can I migrate the sql ce database to my cloud database.
By the way,I can manage the cloud database from my VPS with Navicat.
Jan 17, 2013 12:33 AM|Abhishek Luv|LINK
You can migrate your sql server ce database to sql server express or developer edition using WebMatrix.
Open WebMatrix and go to the Database tab. Next click Migrate and give the database credentials for .sqlexpress or ur any other instance.
After the migration you can create a .bak file of your migrated database and upload it on to your cloud database.
Hope that helps.