How do I manage SDF databases remotely?
This is a silly question but I can't 开发者_StackOverflow社区seem to get a clear idea.
SQL Server CE 4 does not require SQL. So once I copy my .SDF file to my web host, I want to continue making changes only to the remote version and not locally. With a SQL database I would have a connection string and do my thing.
Is it exactly the same with an SDF file? Do I attach them to my SQL Express server to make changes?
You can only open SQL Compact files locally. If you have access to a command prompt on your host machine, you can use my command line utility: http://sqlcecmd.codeplex.com
精彩评论