<div>
Hi aneeshattingal,<br />
<br />
Unfortunately I will not be able to run SQL Server Upgrade Advisor on the 2000 machine before restoring the backup, as it is a shared server, and I will have to request the hosting company does the backup for me and sends me the backup files - which I will then use to restore on 2008.<br />
<br />
Is there any other resource I can use to get the SQL Server Upgrade Advisor information I need?<br />
<br />
thanks<br />
JamWales
</div>


Hi aneeshattingal,

Unfortunately I will not be able to run SQL Server Upgrade Advisor on the 2000 machine before restoring the backup, as it is a shared server, and I will have to request the hosting company does the backup for me and sends me the backup files - which I will then use to restore on 2008.

Is there any other resource I can use to get the SQL Server Upgrade Advisor information I need?

thanks
JamWales

<div>
Hi aneeshattingal,<br />
How do I generate an entire db script from a shared hosting server?<br />
thanks<br />
JamWales<br />

</div>


Hi aneeshattingal,
How do I generate an entire db script from a shared hosting server?
thanks
JamWales


<div>
<div class="content wysiwyg-content">
Hi All,<br />
I want to backup a MSSQL 2000 32bit Standard database and restore it to a MSSQL2008 64 bit Web Edition - is there anything I need to do, as it is moving from a 32bit to 64bit, and different versions of the database.<br />
Thanks<br />
Jamie
</div>
</div>


Hi All,
I want to backup a MSSQL 2000 32bit Standard database and restore it to a MSSQL2008 64 bit Web Edition - is there anything I need to do, as it is moving from a 32bit to 64bit, and different versions of the database.
Thanks
Jamie

MSSQL 2000 32bit Standard backup being restored to MSSQL 2008 64bit Web Edition

Microsoft SQL Server 2008 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. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

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.

Microsoft SQL Server

IIS is Internet Information Services, the web server included with Windows Server operating systems. All current versions are built on a modular architecture; modules can be added or removed individually so that those required for specific functionality are installed. The full installation of IIS includes HTTP, security, content, compression, caching, logging and diagnostics.