<div>
I have sp1 installed and yes they fixed a portion of the generate script - when you select 2000 compatibility it really is 2000 compatible. They still have the issue of either a create or drop not both. I downloaded a handy script generator called Scriptio <a href="http://www.sqlteam.com/publish/scriptio/" rel="ugc">http://www.sqlteam.com/publish/scriptio/</a>&nbsp; <br />
<br />
This does add the DROP/Create and will let you have individual files for each object.
</div>


I have sp1 installed and yes they fixed a portion of the generate script - when you select 2000 compatibility it really is 2000 compatible. They still have the issue of either a create or drop not both. I downloaded a handy script generator called Scriptio http://www.sqlteam.com/publish/scriptio/ [http://www.sqlteam.com/publish/scriptio/] 

This does add the DROP/Create and will let you have individual files for each object.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I am currently working with Microsoft SQL Server 2000. I need to migrate to Microsoft SQL Server 2005. Can you please let me know what can be the possible problems faced while upgrading/migrating and how thay can be avoided? Also, what all factors should be considered while migrating.<br />
<br />
Thanks in advance,<br />
Sanjay.
</div>
</div>


Hi,

I am currently working with Microsoft SQL Server 2000. I need to migrate to Microsoft SQL Server 2005. Can you please let me know what can be the possible problems faced while upgrading/migrating and how thay can be avoided? Also, what all factors should be considered while migrating.

Thanks in advance,
Sanjay.

Migrating to SQL Server 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.