June 30, 2011 at 7:52 pm
How can i downgrade database from Higher Version of (Sql Server 2008 R2) to Lower Version of (SQL server2008)???
I tried many possible way ... but its taking time and getting failed error... can anyone suggest regarding size ... we have many numbers of databse which are on SQL SERVER 2008 R2 but need some database on SQL SERVER 2008. So can anyone suggest!!
Thanks in Advance 🙂
June 30, 2011 at 8:53 pm
You don't.
It's not built to be backwards compatible once you've moved a database to a higher engine.
Rescript all the components, run said scripts on previous version, create SSIS package of doom to push all the data.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 30, 2011 at 9:26 pm
You don't unless it is totally manual.
CEWII
June 30, 2011 at 11:31 pm
kamleshsinhchauhan (6/30/2011)
How can i downgrade database from Higher Version of (Sql Server 2008 R2) to Lower Version of (SQL server2008)???I tried many possible way ... but its taking time and getting failed error... can anyone suggest regarding size ... we have many numbers of databse which are on SQL SERVER 2008 R2 but need some database on SQL SERVER 2008. So can anyone suggest!!
Thanks in Advance 🙂
Hi kamleshsinhchauhan
Check the link and comments too.How to downgrade a database from higher version to lower version
I suggest you to go Replication or BCP. It's good choice for huge DB.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply