Does In-place upgrade set compatibility level to 9.0

This may be very obvious and when I get to the first test server I will find out, but I only have a new installation of SQL2K5 so far to test with. I have several databases that need to be upgraded to run on 2K5, but the application requires them to run in 8.0 compatibility. Does this mean that an in-place upgrade is not an option?

I apologize if this is a silly question, but I have not yet found the answer specifically.

Thanks very much.

No, it does not change the compatibility level. It leaves it at 8.0.|||

So even on an in-place upgrade you still have to go to each database and manually change the compatibility level? This tells me that it only saves me the transfer or moving of the databases themselves, right?

Thanks!

|||

Saves you moving databases, having to export/import logins from master, jobs from msdb, etc.

But it doesn't assume you want compatibility level 9.0 -and that, in my opinion, is a good thing.

Does Fuzzy Lookup work with Oracle ?

Sorry, this might be an obvious question, but I can not find anything in the documentation/forum.

I want to use a Fuzzy Lookup between 2 Oracle tables.

I select the Reference Table.

I then switch to the Columns tab, but the "Available Input Columns" and "Available Lookup Columns" lists are always empty.

I have experimented quite a bit, but to no avail. I noticed this on the Reference Table tabpage : "The table maintenance feature requires the installation of a trigger on the reference table". My guess would be that SSIS does not support Oracle for this, but I am not able to find anything in the documentation that it doesn't.

Any answer/pointer greatly appreciated.

Thanks

Jan Vandepitte

Haven't tried it against Oracle, but my first question would be whether you have permission to create tables and triggers in the db.|||

Hi Jan,

The Fuzzy Lookup and Fuzzy Grouping components are SQL Server only.

I'm sure the answer is also in books online somewhere, but the SSIS Connectivity Wiki has a simple table that shows the data provider options for each of our components.

Hope that helps!

~Matt