Originally Posted by Bert
No offense, and I don't know how good your IT guy/cousin is, but it isn't simple to make an instance on a different type of SQL. There are those who can, though.


I was trying to get this to work for a while ha. I put it on hold until I learn the best practices. Certain conditions have to be met. I.e. the instance name is AmazingCharts, migrating the usernames and passwords without resetting them (tricky), the port numbers, etc. Upgrading an instance from 32 bit to 32 bit is easy. Making a 64 bit instance from scratch can be a little tough. Though I'm sure it's cake for Bert's friend, Raj.
Another thing. It looks like SQL Workgroup Edition (the one that comes with SBS 2011 Premium) is limited at 4GB in the 64 bit edition too so won't be beneficial over the 32 bit edition. (32 bit to 32 bit is easy)