Windows Server 2008 64-bit R2 Standard
ColdFusion Server 9
Greetings. I need to move my database, and could use some advice, please.
Currently I have a server (details above) that hosts about fifty web sites; I see that number slowly growing to a hundred or so over years. The server is located with the reliable, helpful ISP, Viviotech.net.
The web sites use a SQL Server 2005 database located at HostMySite.com. I have used this same database for a long time ... since 2007 or so.
This morning, the database at HostMySite was not available, for mysterious reasons. Network congestion? Who knows. My web sites lost their datasource. Clients unhappy; lots of stress for me.
I think I want to set up a database on the same server noted above -- so, ColdFusion application and a database server would be on the same web server. I would like to get everything under one roof, so to speak.
1) Is this advisable?
2) Can I use a lightweight SQL server like Microsoft® SQL Server 2012 Express
3) Do you think I could export all of the tables in SQL Server 2005 (at HostMySite) and import them into Microsoft® SQL Server 2012 Express and just use that as my datasource for my applications?
4) Any other advice?
I feel vulnerable, and I am not sure what do to. I am grateful for advice. Thank you as always.