How do I move this database online?
January 18, 2012 6:56 AM Subscribe
What's the easiest, most secure way to move this SQL database and its browser-based front end online?
I'm the de facto IT person at a nonprofit, but I have very little formal computer education (like many de facto nonprofit IT people, I have an English degree), so I've never done this before. We have a fairly massive, custom-built database of our clients; it's an SQL database (on Microsoft SQL Server Express) with a web-based front end (written in ASP.net, if that matters). Currently, it's hosted on an in-house server that is NOT connected to the rest of the Internet. My boss wants it moved online so our satellite offices can connect to it, and I'm researching ways of doing that. Naturally, I have questions.
1. I'm guessing that the easiest way would be to rent a virtual server from somewhere like Rackspace. Is that accurate, or would there be a cheaper, easier way?
2. What about security? My boss is very concerned about that. Currently, the database has its own password, as does the in-house server it sits on. If we move this to a virtual server on Rackspace, should we take additional security measures?
3. Considering I've got very little background as a server administrator, what am I overlooking? I'm sure I'm overlooking stuff.
Again, please be gentle, genius IT people of the Hive, and remember, I was an English major, so all this is kind of new to me, but it's been added to my official job description, so there's no backing out now!