Are there any known issues in migrating a SQL Express 2008 database to SQL Server 2008 R2 Standard (x64)? Has anybody done it? I have finally convinced my boss that it would be beneficial to migrate our appliance from Windows XP to Windows Server 2008 R2. Since there is only x64 Server R2, I would like to use SQL Server 2008 x64.
Any shared experiences would be helpful.