Migrating Server 7.0 databases to Server 2000

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)

Migrating Server 7.0 databases to Server 2000

Author

Topic

smittydotbat
Starting Member

2 Posts

Posted - 2007-03-29 : 15:30:37

I must warn whomever reads this as I am a noob when it comes to administering SQL.

I have been trying to take a collection of databases from MSSQL 7.0 and copy them over to MSSQL 2000 using the "Database Copy Wizard".

The server with 7.0 is running on NT 4.0. Server 2000 is running on WinServer 2003.

During the copy phase, I receive the following error:

Step Error Source: Microsoft Data Transformation Services (DTS) PKG
Step Error Description: Unspecified Error
Step Error Code: 800004005
Step Error Help File: sqldts80.hlp
Step Error Help Contect ID: 1100

Has anyone ever encountered this?

For the databases that actually make it over to the new box, they seem to have orphaned the security logins & permissions (doesn't show default database or login name).

Besides copying over the databases, is there a way to copy the security *stuff* over as well?

bryan_smith@lordandtaylor.com

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-03-29 : 15:35:54

why bother with 2000?

2005 has been out for 2 years now, sp2 is available...

www.elsasoft.org