Hi everybody, I am looking to upgrade my websites from a Windows 2008 server with SQL Server 2008 express to Windows server 2012 and SQL Server 2012 express.
I was wondering if anybody had some experience with doing this and if there was any major hassles involved.
I have been able to restore a copy of my SQL 2008 express database to a instance of SQL 2012 express running on my local machine and I keep getting an error when trying to edit the top 200 rows;
Invalid prefix or suffix characters. (MS Visual Database Tools)

Any suggestions and comments would be appreciated.
Regards
Trevor