<div>
take a Full backup and restore it on the destiantion folder then<br />
use this script to <br />
USE [master]<br />
GO<br />
ALTER DATABASE &lt;DATABASE NAME&gt; SET COMPATIBILITY_LEVEL = 100<br />
GO<br />
to change the compatability mode , please have a eye on the Collation mode,
</div>


take a Full backup and restore it on the destiantion folder then
use this script to
USE [master]
GO
ALTER DATABASE <DATABASE NAME> SET COMPATIBILITY_LEVEL = 100
GO
to change the compatability mode , please have a eye on the Collation mode,

<div>
You can upgrade using friendly wizard.
</div>


<div>
PatelAlpesh,<br />
<br />
Do you mean during the sql 2005 setup wizard where it shows you the db instances and says to select one to upgrade?
</div>


PatelAlpesh,

Do you mean during the sql 2005 setup wizard where it shows you the db instances and says to select one to upgrade?

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I'll first preface this by saying that I am by no means a sql database administrator. &nbsp;What I need to do is upgrade my current sql 2000 db to 2005 standard. &nbsp;I have both running on my server (2003 Ent w SP2) and would like to remove sql 2000 completely. &nbsp;<br />
<br />
What steps would I need to undertake, and would I have to do a new instance, or will it just upgrade it in the current location?<br />
<br />
Thanks,
</div>
</div>


Hello,

I'll first preface this by saying that I am by no means a sql database administrator.  What I need to do is upgrade my current sql 2000 db to 2005 standard.  I have both running on my server (2003 Ent w SP2) and would like to remove sql 2000 completely.  

What steps would I need to undertake, and would I have to do a new instance, or will it just upgrade it in the current location?

Thanks,

upgrade sql 2000 db to 2005

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.