April 2, 2012 at 12:10 am
Hi there
I am migrating databases from sql2005 (compatibility mode 80 - sql2000) to sql2008R2
I need to know the following
Is there any T-Sql which was working on SQ2000 will not work on 2008R2? if so, what are they any link will be good
Any thing special i have to configure on DB level etc?
Cheers
Danny
April 2, 2012 at 1:41 am
I believe there is a deprecated feature check. I can't remember if it is on the installation disk or not but one does exist - run that and it should tell you.
April 2, 2012 at 2:16 am
you need SQL Server Upgrade advisor, you can download it here:
April 2, 2012 at 5:02 am
Absolutely run the Upgrade Advisor prior to the upgrade.
I suspect the deprecated code you're thinking of is the old ANSI 89 OUTER JOIN syntax
SELECT *
FROM Table1,Table2
WHERE Table1.ID *= TAble2.ID;
You can't run queries like that in 2008R2
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply