Sorry to bump this thread, but I was just wondering what the current state of upgrading to sql server standard is.
Is there a posted methodology for doing this and will AC support this?
I think its interesting that AC requests a server computer with 8gb of ram when it uses a sql version that is hard limited to 1gb of ram.
Thanks
I am really not sure if SQL will be the answer. The reason they do this is because SQL Express is made so that it can be bundled within software. To require every practice to pay for a full SQL and CALs would be prohibitive. Every time they upgraded to a new SQL version, this would be a new cost.
Maybe allowing for an easy transition which 2012 allows would be helpful. But, it would require a few more techs who are well-versed in SQL. And, couldn't you just see now when a problem arose, and support simply said, it is likely due to your upgrading to full standard. Unless you have a huge practice, I don't think 1GB of RAM is going to hinder you much. Especially when there are those on the board who suggest emptying that cache daily -- something I do not understand.