Copy Data from SQL Express to SQl Server 2005

[rf222]

Hello,

I have started the export wizard, but now I am getting the errors and the wizard stops!

TITLE: Microsoft.SqlServer.DtsTransferProvider
------------------------------

ERROR : errorCode=-1073548784 description=Executing the query "CREATE TABLE [ SQL2005_194896_jiptravelco].[dbo].[aspnet_Applications] (
[ApplicationName] nvarchar(256) NOT NULL,
[LoweredApplicationName] nvarchar(256) NOT NULL,
[ApplicationId] uniqueidentifier NOT NULL,
[Description] nvarchar(256)
)
" failed with the following error: "Database ' SQL2005_194896_jiptravelco' does not exist.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
helpFile= helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}



1) Is there a way to ignore errors and continue with execution?

2) I do not see an option to uncheck (copy database roles, logins etc). Seems MS removed a lot of options from Data Export Wizard...



Here is full report:

Operation stopped...

- Create a TransferProvider. (Success)

- Create a temporary file for destructive SQL. (Success)

- Create a temporary file for constructive SQL. (Success)

- Create a temporary XML file for table metadata. (Success)

- Configure the TransferProvider with files and Source/Destination connection info. (Success)

- Execute the transfer with the TransferProvider. (Error)

Messages

ERROR : errorCode=-1073548784 description=Executing the query "CREATE TABLE [ SQL2005_194896_jiptravelco].[dbo].[aspnet_Applications] (
[ApplicationName] nvarchar(256) NOT NULL,
[LoweredApplicationName] nvarchar(256) NOT NULL,
[ApplicationId] uniqueidentifier NOT NULL,
[Description] nvarchar(256)
)
" failed with the following error: "Database ' SQL2005_194896_jiptravelco' does not exist.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
helpFile= helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC} (Microsoft.SqlServer.DtsTransferProvider)

For help, click:

http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

- Execute the destructive SQL. (drop tables) (Success)

- Execute the constructive SQL. (create tables) (Success)

- Create a temporary table transfer package for [dbo].[aspnet_Applications] (Stopped)

- Execute transfer package for [dbo].[aspnet_Applications] (Stopped)

- Copying to [dbo].[aspnet_Applications] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_Membership] (Stopped)

- Execute transfer package for [dbo].[aspnet_Membership] (Stopped)

- Copying to [dbo].[aspnet_Membership] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_Paths] (Stopped)

- Execute transfer package for [dbo].[aspnet_Paths] (Stopped)

- Copying to [dbo].[aspnet_Paths] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_PersonalizationAllUsers] (Stopped)

- Execute transfer package for [dbo].[aspnet_PersonalizationAllUsers] (Stopped)

- Copying to [dbo].[aspnet_PersonalizationAllUsers] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_PersonalizationPerUser] (Stopped)

- Execute transfer package for [dbo].[aspnet_PersonalizationPerUser] (Stopped)

- Copying to [dbo].[aspnet_PersonalizationPerUser] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_Profile] (Stopped)

- Execute transfer package for [dbo].[aspnet_Profile] (Stopped)

- Copying to [dbo].[aspnet_Profile] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_Roles] (Stopped)

- Execute transfer package for [dbo].[aspnet_Roles] (Stopped)

- Copying to [dbo].[aspnet_Roles] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_SchemaVersions] (Stopped)

- Execute transfer package for [dbo].[aspnet_SchemaVersions] (Stopped)

- Copying to [dbo].[aspnet_SchemaVersions] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_Users] (Stopped)

- Execute transfer package for [dbo].[aspnet_Users] (Stopped)

- Copying to [dbo].[aspnet_Users] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_UsersInRoles] (Stopped)

- Execute transfer package for [dbo].[aspnet_UsersInRoles] (Stopped)

- Copying to [dbo].[aspnet_UsersInRoles] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_WebEvent_Events] (Stopped)

- Execute transfer package for [dbo].[aspnet_WebEvent_Events] (Stopped)

- Copying to [dbo].[aspnet_WebEvent_Events] (Stopped)

- Create a temporary table transfer package for [dbo].[JobsDb_Companies] (Stopped)

- Execute transfer package for [dbo].[JobsDb_Companies] (Stopped)

- Copying to [dbo].[JobsDb_Companies] (Stopped)

- Create a temporary table transfer package for [dbo].[JobsDb_Countries] (Stopped)

- Execute transfer package for [dbo].[JobsDb_Countries] (Stopped)

- Copying to [dbo].[JobsDb_Countries] (Stopped)

- Create a temporary table transfer package for [dbo].[JobsDb_EducationLevels] (Stopped)

- Execute transfer package for [dbo].[JobsDb_EducationLevels] (Stopped)

- Copying to [dbo].[JobsDb_EducationLevels] (Stopped)

- Create a temporary table transfer package for [dbo].[JobsDb_ExperienceLevels] (Stopped)

- Execute transfer package for [dbo].[JobsDb_ExperienceLevels] (Stopped)

- Copying to [dbo].[JobsDb_ExperienceLevels] (Stopped)

- Create a temporary table transfer package for [dbo].[JobsDb_JobPostings] (Stopped)

- Execute transfer package for [dbo].[JobsDb_JobPostings] (Stopped)

- Copying to [dbo].[JobsDb_JobPostings] (Stopped)

- Create a temporary table transfer package for [dbo].[JobsDb_JobTypes] (Stopped)

- Execute transfer package for [dbo].[JobsDb_JobTypes] (Stopped)

- Copying to [dbo].[JobsDb_JobTypes] (Stopped)

- Create a temporary table transfer package for [dbo].[JobsDb_MyJobs] (Stopped)

- Execute transfer package for [dbo].[JobsDb_MyJobs] (Stopped)

- Copying to [dbo].[JobsDb_MyJobs] (Stopped)

- Create a temporary table transfer package for [dbo].[JobsDb_MyResumes] (Stopped)

- Execute transfer package for [dbo].[JobsDb_MyResumes] (Stopped)

- Copying to [dbo].[JobsDb_MyResumes] (Stopped)

- Create a temporary table transfer package for [dbo].[JobsDb_MySearches] (Stopped)

- Execute transfer package for [dbo].[JobsDb_MySearches] (Stopped)

- Copying to [dbo].[JobsDb_MySearches] (Stopped)

- Create a temporary table transfer package for [dbo].[JobsDb_Resumes] (Stopped)

- Execute transfer package for [dbo].[JobsDb_Resumes] (Stopped)

- Copying to [dbo].[JobsDb_Resumes] (Stopped)

- Create a temporary table transfer package for [dbo].[JobsDb_States] (Stopped)

- Execute transfer package for [dbo].[JobsDb_States] (Stopped)

- Copying to [dbo].[JobsDb_States] (Stopped)

- Create a temporary table transfer package for [dbo].[vw_aspnet_Applications] (Stopped)

- Execute transfer package for [dbo].[vw_aspnet_Applications] (Stopped)

- Copying to [dbo].[vw_aspnet_Applications] (Stopped)

- Create a temporary table transfer package for [dbo].[vw_aspnet_MembershipUsers] (Stopped)

- Execute transfer package for [dbo].[vw_aspnet_MembershipUsers] (Stopped)

- Copying to [dbo].[vw_aspnet_MembershipUsers] (Stopped)

- Create a temporary table transfer package for [dbo].[vw_aspnet_Profiles] (Stopped)

- Execute transfer package for [dbo].[vw_aspnet_Profiles] (Stopped)

- Copying to [dbo].[vw_aspnet_Profiles] (Stopped)

- Create a temporary table transfer package for [dbo].[vw_aspnet_Roles] (Stopped)

- Execute transfer package for [dbo].[vw_aspnet_Roles] (Stopped)

- Copying to [dbo].[vw_aspnet_Roles] (Stopped)

- Create a temporary table transfer package for [dbo].[vw_aspnet_Users] (Stopped)

- Execute transfer package for [dbo].[vw_aspnet_Users] (Stopped)

- Copying to [dbo].[vw_aspnet_Users] (Stopped)

- Create a temporary table transfer package for [dbo].[vw_aspnet_UsersInRoles] (Stopped)

- Execute transfer package for [dbo].[vw_aspnet_UsersInRoles] (Stopped)

- Copying to [dbo].[vw_aspnet_UsersInRoles] (Stopped)

- Create a temporary table transfer package for [dbo].[vw_aspnet_WebPartState_Paths] (Stopped)

- Execute transfer package for [dbo].[vw_aspnet_WebPartState_Paths] (Stopped)

- Copying to [dbo].[vw_aspnet_WebPartState_Paths] (Stopped)

- Create a temporary table transfer package for [dbo].[vw_aspnet_WebPartState_Shared] (Stopped)

- Execute transfer package for [dbo].[vw_aspnet_WebPartState_Shared] (Stopped)

- Copying to [dbo].[vw_aspnet_WebPartState_Shared] (Stopped)

- Create a temporary table transfer package for [dbo].[vw_aspnet_WebPartState_User] (Stopped)

- Execute transfer package for [dbo].[vw_aspnet_WebPartState_User] (Stopped)

- Copying to [dbo].[vw_aspnet_WebPartState_User] (Stopped)

 

[jmany1963]

Hi fellow experts
I am also having the same problem with using export/import functions in SQL Server 2005. The error occurs as stated below:

Operation stopped...

- Create a TransferProvider. (Success)

- Create a temporary file for destructive SQL. (Success)

- Create a temporary file for constructive SQL. (Success)

- Create a temporary XML file for table metadata. (Success)

- Configure the TransferProvider with files and Source/Destination connection info. (Success)

- Execute the transfer with the TransferProvider. (Error)

How can go around resolving this problem?

Cheers
James