I'm about to start using SQL 2005 on new hardware. I'm sure I'm not alone.
I thought perhaps people here might share their experiences about upgrading
to 2005 (whether on new hardware or not), and what tips they'd give to
others. Invariably, something goes wrong in the course of a major database
upgrade, and I'm wondering what those things have been for people here.Are you running side-by-side (another instance) or upgrading an
existing 2K instance? I've been running side-by-side on my workstation
since Nov. and have noticed almost no issues.
Also - are you using clustering at all? Don't run a 2K & 2005 on the
same cluster. We've had some issues with that & saw in a Microsoft
sponsored class that was a no-no. Other than that, we love 2005. The
upgrade advisor seems to work well too.
HK wrote:
> I'm about to start using SQL 2005 on new hardware. I'm sure I'm not alone.
> I thought perhaps people here might share their experiences about upgrading
> to 2005 (whether on new hardware or not), and what tips they'd give to
> others. Invariably, something goes wrong in the course of a major database
> upgrade, and I'm wondering what those things have been for people here.|||I'll pull a development database, that has good data, from 2000, attach it
to the new hardware that is running 2005, and make it live for production.
The client application connection strings will change, of course. No
clustering is involved at this moment.
How do you start the Upgrade Advisor? I haven't tried that. The
UI/documentation is, thus far, very lousy for a new version that is 5 years
along. I didn't know there was one.
"Corey Bunch" <unc27932@.yahoo.com> wrote in message
news:1141686052.211469.242010@.z34g2000cwc.googlegroups.com...
> Are you running side-by-side (another instance) or upgrading an
> existing 2K instance? I've been running side-by-side on my workstation
> since Nov. and have noticed almost no issues.
> Also - are you using clustering at all? Don't run a 2K & 2005 on the
> same cluster. We've had some issues with that & saw in a Microsoft
> sponsored class that was a no-no. Other than that, we love 2005. The
> upgrade advisor seems to work well too.
> HK wrote:
> > I'm about to start using SQL 2005 on new hardware. I'm sure I'm not
alone.
> > I thought perhaps people here might share their experiences about
upgrading
> > to 2005 (whether on new hardware or not), and what tips they'd give to
> > others. Invariably, something goes wrong in the course of a major
database
> > upgrade, and I'm wondering what those things have been for people here.
>|||This is a multi-part message in MIME format.
--020908040403080301030804
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
SQL 2005 Upgrade Advisor is a separate download:
http://www.microsoft.com/downloads/details.aspx?FamilyID=451fbf81-ab07-4ccb-a18b-da38f6bcf484&DisplayLang=en
--
*mike hodgson*
http://sqlnerd.blogspot.com
HK wrote:
>I'll pull a development database, that has good data, from 2000, attach it
>to the new hardware that is running 2005, and make it live for production.
>The client application connection strings will change, of course. No
>clustering is involved at this moment.
>How do you start the Upgrade Advisor? I haven't tried that. The
>UI/documentation is, thus far, very lousy for a new version that is 5 years
>along. I didn't know there was one.
>
>"Corey Bunch" <unc27932@.yahoo.com> wrote in message
>news:1141686052.211469.242010@.z34g2000cwc.googlegroups.com...
>
>>Are you running side-by-side (another instance) or upgrading an
>>existing 2K instance? I've been running side-by-side on my workstation
>>since Nov. and have noticed almost no issues.
>>Also - are you using clustering at all? Don't run a 2K & 2005 on the
>>same cluster. We've had some issues with that & saw in a Microsoft
>>sponsored class that was a no-no. Other than that, we love 2005. The
>>upgrade advisor seems to work well too.
>>HK wrote:
>>
>>I'm about to start using SQL 2005 on new hardware. I'm sure I'm not
>>
>alone.
>
>>I thought perhaps people here might share their experiences about
>>
>upgrading
>
>>to 2005 (whether on new hardware or not), and what tips they'd give to
>>others. Invariably, something goes wrong in the course of a major
>>
>database
>
>>upgrade, and I'm wondering what those things have been for people here.
>>
>
>
--020908040403080301030804
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>SQL 2005 Upgrade Advisor is a separate download:<br>
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://www.microsoft.com/downloads/details.aspx?FamilyID=451fbf81-ab07-4ccb-a18b-da38f6bcf484&DisplayLang=en</a><br>">http://www.microsoft.com/downloads/details.aspx?FamilyID=451fbf81-ab07-4ccb-a18b-da38f6bcf484&DisplayLang=en">http://www.microsoft.com/downloads/details.aspx?FamilyID=451fbf81-ab07-4ccb-a18b-da38f6bcf484&DisplayLang=en</a><br>
</tt>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font></span> <b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"><br>
<font face="Tahoma" size="2"><a href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a></font></span>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a></font></span>
</p>
</div>
<br>
<br>
HK wrote:
<blockquote cite="midm04Pf.1448$pV5.620@.tornado.socal.rr.com"
type="cite">
<pre wrap="">I'll pull a development database, that has good data, from 2000, attach it
to the new hardware that is running 2005, and make it live for production.
The client application connection strings will change, of course. No
clustering is involved at this moment.
How do you start the Upgrade Advisor? I haven't tried that. The
UI/documentation is, thus far, very lousy for a new version that is 5 years
along. I didn't know there was one.
"Corey Bunch" <a class="moz-txt-link-rfc2396E" href="http://links.10026.com/?link=mailto:unc27932@.yahoo.com"><unc27932@.yahoo.com></a> wrote in message
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=news:1141686052.211469.242010@.z34g2000cwc.googlegroups.com">news:1141686052.211469.242010@.z34g2000cwc.googlegroups.com</a>...
</pre>
<blockquote type="cite">
<pre wrap="">Are you running side-by-side (another instance) or upgrading an
existing 2K instance? I've been running side-by-side on my workstation
since Nov. and have noticed almost no issues.
Also - are you using clustering at all? Don't run a 2K & 2005 on the
same cluster. We've had some issues with that & saw in a Microsoft
sponsored class that was a no-no. Other than that, we love 2005. The
upgrade advisor seems to work well too.
HK wrote:
</pre>
<blockquote type="cite">
<pre wrap="">I'm about to start using SQL 2005 on new hardware. I'm sure I'm not
</pre>
</blockquote>
</blockquote>
<pre wrap=""><!-->alone.
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">I thought perhaps people here might share their experiences about
</pre>
</blockquote>
</blockquote>
<pre wrap=""><!-->upgrading
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">to 2005 (whether on new hardware or not), and what tips they'd give to
others. Invariably, something goes wrong in the course of a major
</pre>
</blockquote>
</blockquote>
<pre wrap=""><!-->database
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">upgrade, and I'm wondering what those things have been for people here.
</pre>
</blockquote>
</blockquote>
<pre wrap=""><!-->
</pre>
</blockquote>
</body>
</html>
--020908040403080301030804--|||Assuming no syntax errors are present that aren't supported in 2005,
then I think you should be fine. Although, I think it leaves it in 80
(2000) compatability mode if you restore/attach. You might want to go
check the db options after you've done it and try & push it up to 2005.
The upgrade advisor is a must though. Try the link that Mike sent.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment