I'm having quite a difficult problem moving my site. I was developing on a dedicated cloud server which used sql v10.5, and I'm trying to copy my website to my local server which is running sql v10.0. I have tried the following with no luck.
Backup database, try to restore. Failed with error stating backups from newer versions cannot be restored to an older sql version
Export/Import data wizard. This doesn't copy keys over, and only copies data. Site wouldn't load due to missing stored procedures/views/schemas, etc.
Generate Scripts: This gave me the most functionality, my front end was fully functional, although the CMS would not display anything. I would get an error stating there is no definition for dbType String in tblBigList (may not be exact table name, I'm going by memory).
What is the best method for moving a site to an older server? My IIS and server config is the same, it's just a bit older of a db.
I forgot to mention I also installed a blank database and then tried to use episerver's export feature. This worked for everything thus far except the actual page content which it doesn't do anything with.
Well I guess upgrading your local machine would be the easiest but guessing that might not be possible.
Did you try installing a blank database and then use the Export/Import data wizard? That should give you the SP's Views and schemas you need.
Upgrading isn't really an option as the server is hosted through another company and it's fairly locked down as far as upgrading goes. I have tried using a blank database and the export wizard, however this would always give me errors and never complete properly.. The closest I've gotten is by using the generate scripts functionality.. I just ran it again and this is the exact error message I'm getting when I go to edit mode:
Could not map property LanguageBranch - table tblBigTable does not contain any columns that map to DbType.String
From what I've read this is a fairly straightforward process, I'm not sure what exactly I'm doing wrong here.
this is the error message I'm getting in an alert box when I expand the tree to view pages
Error: The target 'FullRegion$explorerTreeView$treeView' for the callback could not be found or did not implement ICallbackEventHandler.
In the event anyone else is having this problem, I fixed it by doing the following:
change .NET version in IIS to 2.0 (was set to 4.0 by default. I read epi does now support 4.0 but my app was built using 2.0)
when building generate scripts, I changed the target to 2005 server (even though I'm running 2008 server) and it transfered everything just fine.
I had exactly the same issue. I used your tip when generating the script to target a specific SQL version. What worked for me was targetting one version older. not the current as that did not work. Thank you!