Migrating from SQL Server 7.0 and SQL Server 2000 to SQL Server 2005

Download details: Microsoft SQL Server 2005 Upgrade Advisor:

http://www.microsoft.com/downloads/details.aspx?familyid=1470E86B-7E05-4322-A677-95AB44F12D75&displaylang=en 

Microsoft SQL Server 2005 Upgrade Advisor analyzes instances of SQL Server 7.0 and SQL Server 2000 in preparation for upgrading to SQL Server 2005. Upgrade Advisor identifies feature and configuration changes that might affect your upgrade, and it provides links to documentation that describes each identified issue and how to resolve it. 

Using the Package Migration Wizard:

http://technet.microsoft.com/en-us/library/ms143496.aspx 

Not all packages can be migrated completely. For example, some SQL Server 2000 tasks do not map to Integration Services tasks, custom tasks cannot be migrated, and some scripts in ActiveX Script tasks or in data transformations cannot be migrated. For more information, see Migrating Tasks <http://technet.microsoft.com/en-us/library/ms143552.aspx&gt; and Known Package Migration Issues http://technet.microsoft.com/en-us/library/ms143462.aspx.

Packages left in the SQL Server 2000 package format can be used in Integration Services solutions and can also continue to run as stand-alone SQL Server 2000 packages.

Many SQL Server 2000 packages are password-protected. If you migrate these packages, the Package Migration Wizard prompts you for their passwords. You cannot migrate a password-protected package unless you provide the correct password.

SQL Server 2005 does not install support for Meta Data Services. The Package Migration Wizard supports Meta Data Services (Repository) packages only if SQL Server 2000, the SQL Server 2000 tools, or the Repository redistributable files are installed on the local computer. When the Repository files are present, the Package Migration Wizard can migrate DTS packages that were saved to Meta Data Services. When the Repository files are not present, the Package Migration Wizard can only migrate DTS packages that were saved to SQL Server or to structured storage files.

Per quanto riguarda invece la virtualizzazione con Virtual Server 2005 Sp1:

Hosting Core Infrastructure Production Workloads Using Microsoft Virtual Server 2005 R2:

http://www.microsoft.com/windowsserversystem/virtualserver/techinfo/hostingcore.mspx

In particular:

Hardware and Software Requirements for Installing SQL Server 2005:

http://technet.microsoft.com/en-us/library/ms143506.aspx

You can install SQL Server 2005 on Microsoft Virtual Server and on Microsoft Virtual PC on supported operating systems and hardware. For information about Virtual Server, see this Microsoft Web site http://go.microsoft.com/fwlink/?LinkId=50379. For information about Virtual PC, see this Microsoft Web site <http://go.microsoft.com/fwlink/?LinkId=50378&gt;.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: