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)
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)
SQL Express to SQl Server 2005 Data Copy
Jorryt
If you are trying to move the entire database, the easiest way is to detach the database in SQL Server Express, copy the .mdf, .ndf, and .ldf files to your SQL Server 2005 server, and then attach the database on the 2005 server. You can also backup the database and restore it on the 2005 server.
Yolande
Thanks, but that is not possible in my case. I have SQL Server 2005 in hosting envirnment. I think I got this working now, I have generated scripts first and executed them on the server. It was more convenient to do this before, because there was a check box for this, now I have to go to different place... One would think that the new version would be simpler...
Lauren Lavoie