SQL 2005 Express

[DavidJenkins]

Hi Guys,

I used to use Access a lot but I have realised the power of MySQL and MSSQL. However wanted to know if this SQL 2005 Data will be easily transferred onto the servers version of MSSQL? Or will I need to get the same version on my system??

Cheers
Dave

[RFH Reseller: Sol]

MS SQL Express is basically a limited version of MS SQL 2005. If you've had some exposure to SQL 2000 then MS SQL Express is similar to the MSDE (MS SQL Server Developer Edition).

At present RFH don't offer MS SQL 2005, although it won't be long before they do (by end of February according to other posts).

You can create a database easily on the RFH server by scripting your SQL Express database and then running those scripts on the RFH server. The tricky part is copying that data over. Using built-in Export method to copy from one SQL Server directly to another does have some caveat's (such as Identity fields having their identity removed).

Hopefully when MS SQL 2005 is installed on RFH servers we will see a better web based admin tool.

[DavidJenkins]

Cheers for the comprehensive answer, right to the point =)