Board index SQL SERVER

SQL Server 2005 DTS Migration Tool (SQL Server 2000 to SQL Server 2005)

SQL Server 2005 DTS Migration Tool (SQL Server 2000 to SQL Server 2005)

Post by d2ba » Tue, 05 Oct 2004 19:54:05


Hi,
I was wondering what is the best practices for migrating existing DTS packages
over to Beta 2 of SQL Server 2005.
I am going to do "sandbox install" of SQL Server 2005 on Virtual PC 2004
and since I will have a clean install Im after ideas?

Thanks in advance
Dave
 
 
 
Top

SQL Server 2005 DTS Migration Tool (SQL Server 2000 to SQL Server 2005)

Post by Allan Mitc » Wed, 06 Oct 2004 04:21:57

You will find detils on how to do this in SQL Server 2005 BOL @

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/44c3d53d-5a9d-41fc-a559-eed51cdf79ed.htm

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com

 
 
 
Top

1. Cluster SQL Server instances (sql server 2000 and sql server 2005)

2. No SQL Server Report Subscriptions Run after SQL Server 2005 Upgrade from SQL Server 2000

3. Confusion - Reporting services, VS 2005, SQL Server 2005, VS 2003, SQL Server 2000

4. How to rung SQL 2005 db on SQL 2000 server - no unique SQL 2005 st

5. SQL queries are slow in SQL Server 2005 when compared with SQL Server 2000

6. Equivalent SQL Code of Pivot(SQL Server 2005) in SQL Server 2000

7. SQL queries are slow in SQL Server 2005 when compared with SQL Server 2000

8. DBF file export issues onWindows 2000 SQL server w/ DTS/ SQL 2005 with DTS

9. SQL Server 2000 and SQL Server 2005 on Virtual Servers

10. Why use SQL Server 2005 over SQL Server 2000 with Project Server 2007?

11. Can we install SQL Server 2000 on same server with SQL Server 2005

12. Windows Server 2008 + SQL Server 2008 OR Windows Server 2003 + SQL Server 2005

13. Can SQL Server 2005 Express and SQL Server 2005 be installed on same machine?

14. migrate from SQL Server 2005 Express to SQL Server 2005 Standard

All times are UTC
Board index