Changing of compability - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Changing of compability

Author

Topic

senpoly
Starting Member

19 Posts

Posted - 2007-06-29 : 01:21:22

hi guys

currently i have the compability of 80 in sql server 2005

and as to use cross apply (which is supported only with compability 90) i have to change it 90, will it conflict any other old stored procedures

please give suggestions

regards

senthil

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-06-29 : 01:24:19

It depends on what your SPs contain. For most of the procs, it should work, for others you have to tweak a little bit.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

Kristen
Test

22859 Posts

Posted - 2007-06-29 : 04:11:55

Assuming you have a production application then I personally think you should do a full regression test before changing from Compatibility-80 to 90.

I have read that Compatibility-80 is considerably slower than Compatibility-90 on SQL 2005, so it is likely to be worth the effort, apart from having access to new features.

Kristen

senpoly
Starting Member

19 Posts

Posted - 2007-06-29 : 08:25:19

thank u kirsten
for u r suggestion
but the problem is how i would that compatibility chananges has effect on stored procedures, there are more than 200 stored procedures and running in a well defined production platform

so tell me wht i have to do exactly

regards

senthil

Kristen
Test

22859 Posts

Posted - 2007-06-29 : 08:45:23

"so tell me wht i have to do exactly"

Set up a copy of the database on a QA server running compatibility-90 and run your Regression Tests.

Kristen

senpoly
Starting Member

19 Posts

Posted - 2007-07-02 : 08:28:22

hi everybody and kirsten

we have checked the queries by setting the compatibility to 90, we feel some thing is going wrong
so, can i create another database and set the compatibility as 90 and run that stored procedure
let me explain u clearly be an example

database :db1
table:emp
compatibility:80
database :db2
compatibilty:90
stored procedure:emp1
create procedure emp1
as
begin
select * from db1.dbo.emp
end

will it work safely

give me suggestion

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-02 : 11:12:49

You can restore the db with new name and set it to level 90, do all testing works in new db.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources