Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
baijuep
Starting Member
15 Posts |
 Posted - 2012-12-21 : 21:28:19
|
| i have a database in sql 2008 and i want it to convert so as to use in sql 2005 is it posiiblebaijuep |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-12-21 : 23:25:06
|
| you cant convert higher version db to lower version. you can do the reverse though. If question is to keep db in 2008 server but make it behave like sql 2005 then you can set compatibility level as 90 to make it behave like 2005------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2012-12-22 : 09:22:42
|
| or Do you mean you have backup of SQL 2008 and you want it to work in SQL 2005? |
|
|
|
|
|
|
convert 2008DB to 2005DB