Copy database Wizard error: "Class not registered"

Hello, I use Management Studio (SQL 2005) on my desktop wich contain also Enterprise Manager (SQL 2000). The SQL Server 2005 is on a server in our network.
When I try to use the function "copy database wizard" to transfer a database SQL 2000 to SQL 2005, the wizard stop with this error:
"Class not registered

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServerAs(Package package, IDTSEvents events, String packagePath, String serverName, String serverUserName, String serverPassword)
at Microsoft.SqlServer.Management.CopyDatabaseWizard.PackageCreator.SavePackage()"

Someone can help?

I am having the same problem with using CopyDatabase wizard in the same enviroment.
I try to copy database from SQL2000 to SQL2005
please help!|||

I have just run into the same problem!

Does anyone have any idea why this is?

|||

Please file a defect report on http://connect.microsoft.com. The product team uses defect reports from the connect site to prioritize future work.

Thanks,
Steve

Copy database Wizard error: "Class not registered"

Hello, I use Management Studio (SQL 2005) on my desktop wich contain also Enterprise Manager (SQL 2000). The SQL Server 2005 is on a server in our network.
When I try to use the function "copy database wizard" to transfer a database SQL 2000 to SQL 2005, the wizard stop with this error:
"Class not registered

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServerAs(Package package, IDTSEvents events, String packagePath, String serverName, String serverUserName, String serverPassword)
at Microsoft.SqlServer.Management.CopyDatabaseWizard.PackageCreator.SavePackage()"

Someone can help?

I am having the same problem with using CopyDatabase wizard in the same enviroment.
I try to copy database from SQL2000 to SQL2005
please help!|||

I have just run into the same problem!

Does anyone have any idea why this is?

|||

Please file a defect report on http://connect.microsoft.com. The product team uses defect reports from the connect site to prioritize future work.

Thanks,
Steve

Copy data and objects between SQL Servers

I have recently moved from a Microsoft SQL Server 2000 to a SQL Server
2005.

In the good old Enterprise Manager, when I imported a table from a SQL
server to another, I could choose "Copy objects and data between SQL
Server
databases". When choosen, all primary keys, and default values was
copied.

My question is:
Is it possible to do the same in Microsoft SQL Server Management Studio
with
SQL Server 2005? And how do I do it?

I have tried using the "SELECT * INTO NewTable FROM OldTable"
statement, but
it just drops all information about primary keys and default values.

Best Regards

The functionality you refer to is now part of SSIS (SQL Server Integration Services). You can access it from the Management Studio in a number of ways. The simplest is to right click on the database you want to import the data into, select all tasks, then select import data...

If you didn't install SSIS with the Database Engine, I'm not sure if you'll be able to access the import functionalty.

See this article on msdn for more info.