SQL 2000 Data to SQL 2008. Moving servers

[SecretSpin]

I am looking to move my stores to another server. Right now the store is hosted on a shared host with a SQL 2000 server. My newest setup will be more decicated with SQL 2008 installed.

I restored the data from 2000 into 2008 and it just breaks the entire system. Is this just not possible. Am I stuck on 2000?

Tried to just use Dataport and move everything that way.. no luck either. It crashes.

Need help and willing to hire someone to do it. Shoot me a PM.

[Shopping Cart Admin]

Hello,

I don't see why 2000 to 2008 data restore would cause any issues with AbleCommerce, did you found a solution?

[SecretSpin]

I have found no resolution to this problem. Logged probably 20-30 hours just trying to get this data from it's current sql to another.

Not even sure how to troubleshoot this. I'm willing to pay if anyone out there has an answer/can do it for me.

[Logan Rhodehamel]

When you say it breaks the entire system, can you describe what breaks? Do you mean the restore process within SQL server itself, or is there a symptom of AbleCommerce crashing? If so, can you provide the error message?

[SecretSpin]

I will have to re-do it again. I attempted to install SQL 2000 w/SQL 2008 installed. Big fail there too.

If I recall it was throwing 'deadlocked' errors'. And that was when it loaded. It mostly just attempted to load.

[southside2005]

I was running AC 7.0.0 on SQL 2000 on one server. I successfully moved it to another server running SQL 2008 simply by doing a datbase backup and restore and received no errors. My store was working fine.

HOWEVER - it turns out this was a big mistake if you ever want to upgrade (which I did). After many many hours and a few support cases I was told that AC 7.0.0 was not supported with SQL 2008 and that I followed an unsupported path so I was on my own.

So here is what I did that ended up working:
1) Went back to my working AC 7.0.0 store with DB version of SQL/2000
2) Upgraded to AC 7.03, still running SQL/2000.
3) Created a localhost (DEV) copy of AC 7.03 running on my local machine that has SQL/2008 installed on it.
4) Backed up my server DB SQL/2000 version and restored it to my local DB SQL/2008 version.
5) Ran the http://localhost/mystore/install/upgradeschema.aspx on my DEV machine. (This is to bring the AC Schema up from ver 2000 to ver 2005)
6) Now I had a working version of AC 7.3 with SQL/2008 running on my local machine, just moved it to our SQL/2008 server with backup/restore and all was finally working.

[SecretSpin]

I eventually got this fixed.

Now I have to move again because I've outgrown another server.

Making the switch next week.