If you have the choice between SqlCe and Sql Server, just take Sql Server. The performance is going to be a lot better.
Being able to change the name of the directory would not add any security, just obscurity. But in any case, it's just a route and you should be able to change it if I'm not mistaken. From: [email protected] [mailto:[email protected]] On Behalf Of Steve Schofield Sent: Thursday, May 12, 2011 4:53 AM To: [email protected] Subject: Re: migration from web matrix sqlce to sql express / sql server fails with cryptic error. Hi Sebastien<mailto:[email protected]>, I migrated my blog content from http://weblogs.asp.net/steveschofield into Orchard with no issues. I have a BUNCH of powershell examples which $ is used as a variable. I'll see if I can find $( which is also used in powershell quite a bit. Should I just start over with a fresh Orchard install and start out with SQL Server as my backend db vs. sqlce? This is the one of the things from holding me up in launching my updated site with Orchard. The other item I want to provide feedback on is being able to change the 'admin' vs to something else. It would be great to have this in configuration vs. hard coded. If someone knows you are running an orchard site, they would automatically know you have an '/admin' exposed. I know there are login and other restrictions we can do so it's not super critical, just a nice to have. Steve On Wed, May 11, 2011 at 10:16 PM, Sebastien Ros <[email protected]<mailto:[email protected]>> wrote: You may have some content or comments with "$(" inside. Even more if you have ever written about jQuery. This is a WebMatrix bug which takes this as an internal command an tries to execute it. Could you try to find this occurrence in your content ? From: Steve Schofield [mailto:[email protected]<mailto:[email protected]>] Sent: Wednesday, May 11, 2011 6:27 PM To: [email protected]<mailto:[email protected]> Subject: migration from web matrix sqlce to sql express / sql server fails with cryptic error. 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(DeploymentObject destParent, DeploymentObject sourceObject, Int32 position) at Microsoft.Web.Deployment.DeploymentSyncContext.SyncChildrenOrder(DeploymentObject dest, DeploymentObject source) at Microsoft.Web.Deployment.DeploymentSyncContext.SyncChildren(DeploymentObject dest, DeploymentObject source) at Microsoft.Web.Deployment.DeploymentSyncContext.SyncChildrenOrder(DeploymentObject 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.<StartMigrate>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]<mailto:[email protected]>. To unsubscribe send a blank email to [email protected]<mailto:[email protected]>. --- You are currently subscribed to orchard-discuss as: [email protected]<mailto:[email protected]>. To unsubscribe send a blank email to [email protected]<mailto:[email protected]>. --- You are currently subscribed to orchard-discuss as: [email protected]<mailto:[email protected]>. To unsubscribe send a blank email to [email protected]<mailto:[email protected]>. --- You are currently subscribed to orchard-discuss as: [email protected]. To unsubscribe send a blank email to [email protected].
