import and export database in sql server

Question

Hello i have one existing sql server 2008 express r2 database file. in my mechine there is only sql server 2008 express. how to open that existing file in sql server 2008 express.

Renish Patel · Answer

You can't attach/restore a 2008 R2 database to a 2008 instance. You either need to upgrade the 2008 instance to 2008 R2 or you need to move the schema and data in another way. For Example You can generate the scripts from the sql server 2008 express r2 instance and run them on the 2008 express instance. This can solve your problem Thanks Renish Patel

Renish Patel · Answer

your welcome please make this post as answered... Thanks

sujit kalagara · Answer

Thanks a lot Mr. Renish Patel