November 2, 2010 at 2:29 pm
Hi,
I've just moved my primary system to Windows 7 and installed SSMS and BIDS for SQL 2008 R2. All our production systems are running SQL Server 2008 (not R2) or SQL Server 2005, and opening a SQL Server 2005 SSIS package (haven't tried 2008 yet) in BIDS for SQL Server 2008 R2 it launches a Conversion Wizard.
So I take it I'll probably need SQL Server 2005 to modify SSIS packages for servers running SQL 2005, but what about SQL 2008?
I'm trying to avoid having to run so many concurrent versions of everything, but I might not be able to void it I guess.
Also note, I thought I posted this earlier today, but the post didn't come up when I searched for my name or skimmed the Forum I posted under.
Thanks --
Sam
November 2, 2010 at 2:41 pm
There isn't backwards compatibility between 2005 and 2008. You can upgrade a SQL Server 2005 package to a SQL Server 2008 package with a wizard. Typically the only manual edit that I've had to make is in the connection string for the data sources, but other than that it is fairly smooth. You won't be able to read 2008 or higher packages with BIDS 2005.
I'm honestly not sure if SQL Server 2008 can read a SQL Server 2008 R2 package or not. I would imagine so, but am curious myself to confirm.
November 2, 2010 at 2:43 pm
samalex (11/2/2010)
Hi,I've just moved my primary system to Windows 7 and installed SSMS and BIDS for SQL 2008 R2. All our production systems are running SQL Server 2008 (not R2) or SQL Server 2005, and opening a SQL Server 2005 SSIS package (haven't tried 2008 yet) in BIDS for SQL Server 2008 R2 it launches a Conversion Wizard.
So I take it I'll probably need SQL Server 2005 to modify SSIS packages for servers running SQL 2005, but what about SQL 2008?
I'm trying to avoid having to run so many concurrent versions of everything, but I might not be able to void it I guess.
Also note, I thought I posted this earlier today, but the post didn't come up when I searched for my name or skimmed the Forum I posted under.
Thanks --
Sam
You need BIDS 2005 for SQL 2005 packages and BIDS 2008, or 2008 R2, for SQL 2008 packages.
SSIS packages for SQL 2005 and 2008 are not compatible with each other, as you seem to have noticed.
SQL 2005 packages can be easily upgraded to 2008 but will then no longer run on SQL 2005. There is no downgrade option to convert 2008 packages back to 2005.
BIDS for SQL 2008 R2 can be used with SQL 2008 packages. BIDS for SQL 2008 could have some problems with 2008 R2, but that should only happen if you're using one of the few new 2008 R2 components.
BIDS 2005 and 2008/2008R2 can co-exist on the same machine.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
November 2, 2010 at 2:46 pm
Alvin Ramard (11/2/2010)
SQL 2005 packages can be easily upgraded to 2008 but will then no longer run on SQL 2005. There is no downgrade option to convert 2008 packages back to 2005.
Alvin explained things a lot more eliquiently.
This is a really important point to remember. Definitely keep a backup of your 2005 packages before you upgrade!
November 2, 2010 at 2:49 pm
tmitchelar (11/2/2010)
Alvin Ramard (11/2/2010)
SQL 2005 packages can be easily upgraded to 2008 but will then no longer run on SQL 2005. There is no downgrade option to convert 2008 packages back to 2005.
Alvin explained things a lot more eliquiently.
This is a really important point to remember. Definitely keep a backup of your 2005 packages before you upgrade!
What timing? While you were writing this, I was adding a few words to your comment about blocking in another post. 😀
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
November 2, 2010 at 3:02 pm
Alvin Ramard (11/2/2010)
What timing? While you were writing this, I was adding a few words to your comment about blocking in another post. 😀
You complete me :hehe:
November 2, 2010 at 3:08 pm
tmitchelar (11/2/2010)
Alvin Ramard (11/2/2010)
What timing? While you were writing this, I was adding a few words to your comment about blocking in another post. 😀
You complete me :hehe:
:w00t:
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply