Copy Data from SQL Server 2005 Express to Dsicount ASP SQl Server 2005

[iwantioffer]

Hello,


I have started the 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)
<DIR>
<DIR>


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&amp;LinkId=20476
</DIR></DIR>


- 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)

[iwantioffer]

Thanks I figure it out already. I did exactly like your article suggested... The new vesrion makes it more complex... It used to be simple, just one checkbox...

[junior]

RAFAL,

Its is more likely that the transferring on the data to the sql 2005 servers is having problems withreferential integrity... try following the method we just posted - http://community.discountasp.net/default.aspx?f=16&amp;m=8808oncopying the the database objects to a sql 2005 database


junior

DiscountASP.NET

www.DiscountASP.NET (http://www.DiscountASP.NET)