Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Updating from SQL 7 or 2000 to 2005

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-10-06 : 07:40:10
yudi writes "I wanna update SQL 2000 to 2005. Before doing that, i got some questions:

1. Can i replicate database from SQL to 2005? How bout SQL 2000 to 2005? will it compatible?

2. How bout the DTS? Can i just pass the DTS Package i made in SQL 2000 to SQL 2005 DTS? or i have to make a new one with the same logic? as long as i know, coding in DTS 2005 is different from the 2000's.

3. If i do data migration from 2000 to 2005, will the user account in SQL 2000 be migrated too? or still i should create the user account manually.

thx b4..."
   

- Advertisement -