Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
770 views
in Technique[技术] by (71.8m points)

c# - restore SQL 2008 DB R2 to SQL2008 (no r2)

on my developper pc is installed SQL 2008 R2
on the internal server is installed SQL 2008 R2 (some applications are hosted here)
on the external 3.rd party hosting company uses SQL 2008 (no r2).

so when I created DB on my developper pc I need to restore on external hosting server which is SQL 2008 (w/o r2).... but I get an build version error... it says SQL2008 r2 has higher build number so I can't restore on the w/o r2 server.

I thought creating the DB on w/o R2 server and restore on my localhost and make changes and restore back to w/o r2 server, but it says the same error... Build number is changed.

I thought I can delete r2 version on my developper pc and use SQL 2008 w/o r2, but the issue remains I can't restore the DB from internal server to my developper pc...:(

so in short: If I want to restore/backup the DB between SQL2008 R2 and SQL2008, how to handle this (I als need the data of database ? Any property to assign to the DB or whatever?

Is there a procedure that I can use SQL2008 R2 DB as SQL2008 DB?

I can't touch the SQL 2008 versions on the server...

please advice?

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)

You have to export/import using the wizard in SSMS. Or use some 3rd party tool (eg Red Gate)

There is NO downgrade option using attach/detach or backup/restore. And no magic setting.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...