Migratet database from SQL server EXP 2005 to SQL server 2008 EXP r2

[utsav]

Hello,

How can I migrate database from SQL EXP server 2005 to SQL server EXP 2008 r2?

Any suggestion will be appropriated

[Kailash]

You can generate backup of your database from SQL 2005 server and then you can restore it in SQL 2008 R2 server. You should be able to restore without any issue.

- Kailash

[utsav]

Hello,

Thanks for your reply...

Do you mean .bak file?

IS it possible to backup and restore from old WSP to new one?

[Kailash]

Yes, I was referring .bak file. You can try to restore it directly from WebsitePanel.