I'm trying to migrate my sqlce database and getting this error below. I tried SQL Server and sql express with no luck. Any advice?
The migration of the database from SQL Server Compact to SQL Server failed. --------------------------- Migration failed --------------------------- Migration failed An error occurred during execution of the database script. The error occurred between the following lines of the script: "5800" and "5812". The verbose log might have more information about the error. The command started with the following: "INSERT INTO [dbo].[Common_BodyPartRecord]([Id],[Co" --------------------------- OK --------------------------- --------------------------- Microsoft.Web.Deployment.DeploymentException: An error occurred during execution of the database script. The error occurred between the following lines of the script: "5800" and "5812". The verbose log might have more information about the error. The command started with the following: "INSERT INTO [dbo].[Common_BodyPartRecord]([Id],[Co" ---> ManagedBatchParser.ParserException at ManagedBatchParser.Parser.Parse() at Microsoft.Web.Deployment.SqlBatchParser.ProcessSqlCmdScript(String sqlCmdScript) at Microsoft.Web.Deployment.SqlScriptToDBProvider.AddHelper(DeploymentObject source, Boolean whatIf) --- End of inner exception stack trace --- at Microsoft.Web.Deployment.SqlScriptToDBProvider.AddHelper(DeploymentObject source, Boolean whatIf) at Microsoft.Web.Deployment.SqlScriptToDBProvider.Add(DeploymentObject source, Boolean whatIf) at Microsoft.Web.Deployment.DeploymentObject.AddChild(DeploymentObject source, Int32 position, DeploymentSyncContext syncContext) at Microsoft.Web.Deployment.DeploymentSyncContext.HandleAddChild(DeploymentObje ct destParent, DeploymentObject sourceObject, Int32 position) at Microsoft.Web.Deployment.DeploymentSyncContext.SyncChildrenOrder(DeploymentO bject dest, DeploymentObject source) at Microsoft.Web.Deployment.DeploymentSyncContext.SyncChildren(DeploymentObject dest, DeploymentObject source) at Microsoft.Web.Deployment.DeploymentSyncContext.SyncChildrenOrder(DeploymentO bject dest, DeploymentObject source) at Microsoft.Web.Deployment.DeploymentSyncContext.SyncChildren(DeploymentObject dest, DeploymentObject source) at Microsoft.Web.Deployment.DeploymentSyncContext.ProcessSync(DeploymentObject destinationObject, DeploymentObject sourceObject) at Microsoft.Web.Deployment.DeploymentObject.SyncToInternal(DeploymentObject destObject, DeploymentSyncOptions syncOptions, PayloadTable payloadTable, ContentRootTable contentRootTable) at Microsoft.Web.Deployment.DeploymentObject.SyncTo(DeploymentProviderOptions providerOptions, DeploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions) at Microsoft.Web.Deployment.DeploymentObject.SyncTo(String provider, String path, DeploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions) at Microsoft.Web.Deployment.DeploymentObject.SyncTo(DeploymentWellKnownProvider provider, String path, DeploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions) at Microsoft.WebMatrix.DatabaseManager.Client.SqlCeHelper.<>c__DisplayClass6.<S tartMigrate>b__5(Object sender, DoWorkEventArgs eventArgs) at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e) at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument) --------------------------- Thank you, Steve Schofield Windows Server MVP - IIS http://weblogs.asp.net/steveschofield --- You are currently subscribed to orchard-discuss as: [email protected]. To unsubscribe send a blank email to [email protected].
