Click here to Skip to main content
15,889,281 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi i have a sql database .mdf and i was wondering if i can put my database online eg. dropbox or some place and then connect to it with microsoft sql management studio.
if this is possible how? or an article i can read/follow.

the reason is: i have a project that uses winforms(c#) and a php website and a mobile app. and i must use one database to do add/modify/delete and select.
Posted

Yes, you can. But it probably isn't a brilliant idea to just post up the MDF file and access it.
Although you can do that, it does leave you somewhat vulnerable to external accesses - particularly if you are giving modify / delete access to anybody!

I would be tempted to write a WebService instead, which used MsSql to access the database, and which passed requests through from your various apps once they had logged in and verified themselves. It's more work, but it's a lot safer (and quicker than restoring the database after is is corrupted beyond repair)
 
Share this answer
 
i understand your idea. but for now i just i just want it online so all apps can use database. because its for a project i an not so concerned with the security.
that’s why i will like to use dropbox. but thanks for the idea i am definitely doing more research on that.
if you can help me with the dropbox idea i will appreciate it. or how to go about it.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900