Hi Lee and other forum readers,

I've been watching the videos from magazine issue 22 on making a local copy of the DNN installation. That is some good work there Lee. Just what I am needing to understand right now! My question is, my shared host is running SQL server 2000 and I have installed SQL Server 2005 Express on my local server. I want to make a working copy of their DB on my network. Will there be extra steps to go from 2000 to 2005?

I have SQL Server 2000 installation disks, and another computer available. Would it be better to get that running instead so I don't have any conversion issues? (Id rather not, but I can if I must)

Thanks is advance!

Hi Datamark,

From my experience working with SQL Management Studio Express, there shouldn't be any extra steps. SQL 2005 is backwards compatible with SQL 2000. I use SQL Management Studio Express to access SQL 2000 and 2005 databases on our servers all the time. It is also possible to restore a SQL 2000 backup copy into a SQL 2005 database.

While you can restore at 2000 backup into 2005, going in the other direction isn't possible. So, if you intend to try to move databases in both directions, you'll want to install SQL Server 2000 on your local machine, or at least use one.

Remember, too, that you don't have to have the SQL Server on your local machine. If you have access to the SQL server on your "live" machine you could install a live database and a test database. You just change your connection string to connect the local DNN installation to the remote "testing" database.

Hello,

I would recommend you check out virtual PC - it's free and it's recently completely transformed the way I work. This will allow you to set up a virtual environment with SQL Server 2000 and it won't interfere with your current installation, I highly recommend you take the time to check it out. Thanks,

3 very helpful replies! Thank you all for your time. I know it is precious. 

ihostasp, I was using an old copy of Enterprise Manager to get into the old SQL Server 2000 databases. I hadn't even tried to use the SQL MSE to do it. Thanks for that tip.

jncraig, your idea of having the live and test databases on the same SQL Server 2000 installation is a great solution for testing and for recovering from problems with the live database, however one of my goals is to get a copy of everything working on my local server so that in case the host goes down, or cuts me off for who knows what reason, I'm prepared with copies of the whole deal and can recover it all to another host ASAP. Still, I just might use your suggestion for it's obvious benefits.

Lee, intriguing suggestion. Are you suggesting I run a VPC on my PC, not my server, and have SQL Server 2000 running on there? I'd be very interested to hear how else you are using Virtuap PC to your advantage. I have it installed and I have successfully installed Win XP in a VPC. But I have not activly used the VPC so far. I have a dual boot PC here. WinXP and Vista. What I was trying to do was to restore an image of the the WinXP installation into the Windows Vista hosted Virtual PC. So Vista is the host, XP is in a VPC. Then I think I would remove the original XP installation from the PC. That way I'd have both OS's running concurrently instead of one at a time.  Did you do a restore into your VPC or did you install an OS from scratch? Thanks for time Lee. I love your tutorials. You have a gift.

-datamark 

Yes a VPC on your PC. I installed an OS from scratch. - It's very useful for testing in a variety of browsers etc. - You can have different versions of IE in various VPCs for testing.

I have several VPCs setup and each is set for different tasks, ie. tutorials with VWD express etc., a separate FTP VPC etc.

I resorted to doing this after having backups of all my data and suffering from a couple of big hardware failures. - I can recover the data, but I can't recover the hours of setup time of various programmes etc.

This way if I have a hardware failure I can just move the VPC to another computer and be up and running in minutes without worrying about configuring windows, drivers and programmes for new hardware.

If I am away, I also move VPCs to a laptop so that I can work using the exact setup of my main computer.

Hope this gives you an idea of what I use it for, cheers,

Thanks Lee!

Hi Lee,

I have been a subscriber to your videos, and wanted to say that they have been very useful. Thank you for providing a valuable product to the DNN Community. I have been reading through the forums looking for assistance in moving from a MSSQL 2000 - 2005 enviroment, and have created then restored a 2000 backup in 2005. I then have copied over my files, updated the web.config, etc. and have been getting this error:

--------------------------------------------------------------------------------
Invalid access to memory location. (Exception from HRESULT: 0x800703E6)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.BadImageFormatException: Invalid access to memory location. (Exception from HRESULT: 0x800703E6)

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[BadImageFormatException: Invalid access to memory location. (Exception from HRESULT: 0x800703E6)]
System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) +0
System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) +54
System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +211
System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +141
System.Reflection.Assembly.Load(String assemblyString) +25
System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +32

[ConfigurationErrorsException: Invalid access to memory location. (Exception from HRESULT: 0x800703E6)]
System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +596
System.Web.Configuration.CompilationSection.LoadAllAssembliesFromAppDomainBinDirectory() +211
System.Web.Configuration.CompilationSection.LoadAssembly(AssemblyInfo ai) +46
System.Web.Compilation.BuildManager.GetReferencedAssemblies(CompilationSection compConfig) +177
System.Web.Compilation.BuildProvidersCompiler..ctor(VirtualPath configPath, Boolean supportLocalization, String outputAssemblyName) +185
System.Web.Compilation.CodeDirectoryCompiler.GetCodeDirectoryAssembly(VirtualPath virtualDir, CodeDirectoryType dirType, String assemblyName, StringSet excludedSubdirectories, Boolean isDirectoryAllowed) +350
System.Web.Compilation.BuildManager.CompileCodeDirectory(VirtualPath virtualDir, CodeDirectoryType dirType, String assemblyName, StringSet excludedSubdirectories) +125
System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +378

[HttpException (0x80004005): Invalid access to memory location. (Exception from HRESULT: 0x800703E6)]
System.Web.Compilation.BuildManager.ReportTopLevelCompilationException() +57
System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +612
System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters) +644

[HttpException (0x80004005): Invalid access to memory location. (Exception from HRESULT: 0x800703E6)]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +3465427
System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +69
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +279



Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433
--------------------------------------------------------------------------------


Any ideas as to how to resolve this issue?

Thanks,
Joe

 hi lee,

as per my practices, in sql server 2000 and sql server 2005 express or developer enterprise edtion, sql server 2005 is backward compitatable. so you can restore backup of sql server 2000 database to sql server 2005 or directly attach the mdf and ldf file also. so u don't need to follow any extra step for that

Hi Joe,

I'm unsure how to fix that error, I have not come across a memory error before, have you had any luck yet finding the problem?

Hi Lee,

Thanks for taking a look. I have not found the solution yet. I was able to move some other DNN sites without a problem. I am going to try removing some modules and see if that helps. I will post to the forum if I get it to work or ca figure out what the error is.

The site is a few modules, some text, etc. My Plan B, which might be quicker, is to restore the site on the old server, and then set up a new instance of DNN and just copy over the text and modules, etc.

Thanks again,
Joe

Hi Joe,

I'm getting the same error having copied one of my DNN portals from my PC to my laptop - which I've done dozens of times before.

Now, I'm getting this error and can't figure out why.

I wish I had better news...but I was unable to figure out what caused this error and ended up having to rebuild the site from scratch.

The only advice I can think of is to make sure you are upgraded to DNN 4.8.4 and that the version of ASP.NET is exactly the same on both computers.

Good Luck, I can empathize with you on this one.

Joe

Are there any work arounds. I developed an entire website on SQL Express 2005 and now my host supports only SQL 2000 at this time. Am I screwed?

thx,
seed

It maybe worth contacting your hosting provider to see if they know of any techniques for doing this.

This is a late reply, but still relevant issue experienced when moving a DNN site to a new server.

Invalid access to memory location. (Exception from HRESULT: 0x800703E6)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.BadImageFormatException: Invalid access to memory location. (Exception from HRESULT: 0x800703E6)

______________________________________________________________________________________________
This error occurs when using the wrong .NET Framework setting on your webserver.
In Webmatrix, the setting is located under Site>Settings>Select .Net Framework Version.

If you use IIS: http://technet.microsoft.com/en-us/...s.10).aspx

I received the same error prior to setting my servers framework to .NET 4 (Integrated)