|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
|
|
|
||||||
| ms.sqlserver.setup Questions about SQL Server. |
 |
|
|
LinkBack | Outils de la discussion |
12/07/2007, 17h23
|
#1 |
Messages: n/a
Hébergeur: |
compatibility 8.0
I performed an in-place upgrade from SQL 2k to SQL2k5 last night.
Everything worked well, but I was a little surprised that the dbs were left in 8.0 compatibility mode. Is this on purpose, or did I miss a checkbox somewhere that would have upgraded the dbs to 9.0 compatibility mode? Thanks, Andre |
|
|
12/07/2007, 17h53
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: compatibility 8.0
It is on purpose. It is easy to change compat level after the upgrade.
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Andre" <nospam@spam.com> wrote in message news:%23tA10DKxHHA.4436@TK2MSFTNGP03.phx.gbl... >I performed an in-place upgrade from SQL 2k to SQL2k5 last night. > Everything worked well, but I was a little surprised that the dbs were left > in 8.0 compatibility mode. Is this on purpose, or did I miss a checkbox > somewhere that would have upgraded the dbs to 9.0 compatibility mode? > > Thanks, Andre > > |
|
|
|
12/07/2007, 18h23
|
#3 |
|
Messages: n/a
Hébergeur: |
Re: compatibility 8.0
Thanks, just wanted to be sure. Yes, it's easy to change.
Andre |
|
|
|
12/07/2007, 23h20
|
#4 |
|
Messages: n/a
Hébergeur: |
Re: compatibility 8.0
Same thing happens when you restore an SQL2000 backup to SQL2005.
Chris "Andre" <nospam@spam.com> wrote in message news:%23tA10DKxHHA.4436@TK2MSFTNGP03.phx.gbl... >I performed an in-place upgrade from SQL 2k to SQL2k5 last night. >Everything worked well, but I was a little surprised that the dbs were left >in 8.0 compatibility mode. Is this on purpose, or did I miss a checkbox >somewhere that would have upgraded the dbs to 9.0 compatibility mode? > > Thanks, Andre > |
|
|
|
25/07/2007, 05h40
|
#5 |
|
Messages: n/a
Hébergeur: |
Re: compatibility 8.0
Will the upgrade modify the script to change those "*=" to left outer
join? Ivan "Chris Wood" <anonymous@microsoft.com> ¼¶¼g©ó¶l¥ó·s»D:OZj2CMNxHHA.3560@TK2MSFTNGP02.phx.g bl... > Same thing happens when you restore an SQL2000 backup to SQL2005. > > Chris > > "Andre" <nospam@spam.com> wrote in message > news:%23tA10DKxHHA.4436@TK2MSFTNGP03.phx.gbl... >>I performed an in-place upgrade from SQL 2k to SQL2k5 last night. >>Everything worked well, but I was a little surprised that the dbs were >>left in 8.0 compatibility mode. Is this on purpose, or did I miss a >>checkbox somewhere that would have upgraded the dbs to 9.0 compatibility >>mode? >> >> Thanks, Andre >> > > |
|
|
|
| Outils de la discussion | |
|
|
