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 |
|
jasminegirl
Starting Member
7 Posts |
 Posted - 2010-02-13 : 16:36:50
|
| I have a couple the questions to ask about sql server 2005 versus sql server 2008 since I am new to sql server. (My small company will be using sql sever 2008 within the next month or two: 1. Can I use the SSIS manager 2005 on the sql server 2008 database? 2. Can I use the SSIS manager 2008 on a sql server 2005 database? 3. What are the other new sql features in sql server 2005 and links as references for these new features? 4. What are the other new sql features in sql server 2008 and links as references for these new features? 5. Between sql server 2005 and sql server 2008, are there sql statements that are deprecated (Not valid any more)? If so what are the deprecated features? |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-14 : 02:56:04
|
5) Microsoft have a Upgrade Advisor tool that will tell you about things in your code that need modification3 & 4 are readily available on Microsoft's site. I could search for a link for you, but I'm sure you can do that too  There is a thread here about migrating to SQL 2008:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=1382301) I can't get SQL 2005 SSMS to connect to SQL 2008 (but I haven;t installed the latest service pack yet). The error message specifically says "Can only connect to SQL 2000 and SQL 2005). However, my SQL 2000 Query Analyser happily connects to SQL 2005 and SQL 2008.But I don't know about SSIS |
 |
|
|
|
|
|
sql 2005 versus sql 2008