I have a SQL Server 2008 Express server installed for a development database.
I am testing a web project for a client and his database is SQL Server 2008 R2 and I want to import his database into my test server for testing until we go live.
Is this possible? Or will I have to upgrade to 2008 R2 . . .and if so how difficult would this be? I'm a programmer and know my way around the SQL server management studio (enough to be dangerous anyway). But I didn't install the software to begin with and don't know much about the installation or upgrade process.
Thanks for any input!