January 31, 2011 at 8:48 am
I am planning to have 2005 in my Dev environment and 2008 on my production.
Rep DB are on 2005 too.
What kind of issues i would face regards to
1. Developing packages (SSIS .etc ) on 2005 and move them to production on 2008
2. Mirroring the Prod DB and taking snap shots from prod n placing them on Reporting DB (2005)
3. Anything more that i didnt mention here ?
Please help
Thanks
[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]
January 31, 2011 at 8:58 am
why do you NOT want matching systems??
It usually causes way more problems than anything else.
January 31, 2011 at 9:09 am
You cannot move snapshots or backups, from 2008 to 2005. You can script out the database and move the data, but you can't make this happen easily. You cannot mirror from 2008 to 2005.
As far as packages, it's hard to know what might break there. Most of the 2008 stuff should be backwards compatible, but you might find something that doesn't work.
You are somewhat asking for trouble if your dev environment doesn't match production. At the least, you should set up a VM with 2008 in it for development against that version
January 31, 2011 at 9:17 am
Iam not able to afford one for Dev too. I have some sensitive data on 2008 which needs enhanced protection thats the reason i am planing to move to 2008 atleast for my Prod environment, wher I have my live data which needs to folow certain complainaces.
ALTER DATABSE SET compaitability level = 90
Would this help ?
Are these the problems you are talking about ?
[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]
January 31, 2011 at 9:17 am
oops i forgot to paste the link ..
http://msdn.microsoft.com/en-us/library/bb510680.aspx
[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]
January 31, 2011 at 9:21 am
Thanks steve , it makes sense.
One more question,What kind of problems/issues i have to face
If i leave my reporting environment in 2005 and move both Prod n Dev to 2008.
How do i feed/refresh the data on the 2005 boxes from my 2008.
Thanks
[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]
January 31, 2011 at 9:24 am
Allin
ALTER DATABSE SET compaitability level = 90
If you read your link, it keeps saying that Compatibility level provides only partial backward compatibility with earlier versions of SQL Server.
As Ninja said, you will be opening a can of worms. You will be coding for an older version of SQL Server, and not leveraging the newest changes. You may even be using some processes which may no longer exist in 2008.
IMOH VERY BAD MOVE
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
January 31, 2011 at 9:24 am
allin1 (1/31/2011)
Thanks steve , it makes sense.One more question,What kind of problems/issues i have to face
If i leave my reporting environment in 2005 and move both Prod n Dev to 2008.
How do i feed/refresh the data on the 2005 boxes from my 2008.
Thanks
I'm not even sure that could work. rdls from bids 208 can't be used on 2005. Maybe there's a way but then again it's just asking for trouble.
What do you mean you can't affort a dev version of 2008??? It's like 60$?!?!
January 31, 2011 at 9:27 am
The main problem you will have is moving your data to 2005 from 2008. You can use replication or custom SSIS packages to move the data.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply