I have some old SQL servers that I cannot upgrade becuase of the application
that uses them. Can I manage these servers from SQL 2005? IF so, are there
any known gotchas? Thanks in advance.
--
BettieYou can do all most common tasks using the new 2005 Studio, the "new and
improved" features won't work however
like i.e. Preformance Tunning Wizard.
By the way - I haven't seen any issues with my "legacy" application after
upgrading to 2005 server, as long as you keep
the specific databases on SQL2000's compatibility level (uprgade process
leaves them there by default).
rgrds
rafael
"Bettie Claxton" <BettieClaxton@.discussions.microsoft.com> wrote in message
news:0E984055-B655-4094-91A5-5B45C998545B@.microsoft.com...
>I have some old SQL servers that I cannot upgrade becuase of the
>application
> that uses them. Can I manage these servers from SQL 2005? IF so, are there
> any known gotchas? Thanks in advance.
> --
> Bettie|||No problems. I am using SQL 2005 Management studio to manage couple of my
SQL 2000 servers.
But the other way will not work out...
Thanks
Hari
"Bettie Claxton" <BettieClaxton@.discussions.microsoft.com> wrote in message
news:0E984055-B655-4094-91A5-5B45C998545B@.microsoft.com...
>I have some old SQL servers that I cannot upgrade becuase of the
>application
> that uses them. Can I manage these servers from SQL 2005? IF so, are there
> any known gotchas? Thanks in advance.
> --
> Bettie|||Thanks -- I'll try the upgrade in the lab.
--
Bettie
"Rafael Lenartowicz" wrote:
> You can do all most common tasks using the new 2005 Studio, the "new and
> improved" features won't work however
> like i.e. Preformance Tunning Wizard.
> By the way - I haven't seen any issues with my "legacy" application after
> upgrading to 2005 server, as long as you keep
> the specific databases on SQL2000's compatibility level (uprgade process
> leaves them there by default).
> rgrds
> rafael
>
> "Bettie Claxton" <BettieClaxton@.discussions.microsoft.com> wrote in messag
e
> news:0E984055-B655-4094-91A5-5B45C998545B@.microsoft.com...
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment