I have tried upgrading my sql 2005 to SQL 2008.
I've got many error, i was lucky my CRM as no trouble at all.
I would like to migrate to SQL 2008 but now with SQL 2008 to another server.
My question is simple : how can i move my DB from Server 1 with SQL 2005 to Server 2 with SQL 2008 without too much trouble ?
In advance many thanks for all help.
Actual server is :
1x W2K3 DC+CRM+Sql2005 3 gb Ram
1x W2K3 64 bits Exchange 2007 4 Gb Ram
1x W2K8 32b TS server
i would like to add one new server with SQL 2008 and remove SQL 2005 from server 5 and migrate my SQL CRM 4 DB.