SQL 2000 Data to SQL 2008. Moving servers
-
- Ensign (ENS)
- Posts: 19
- Joined: Thu Oct 29, 2009 5:34 am
SQL 2000 Data to SQL 2008. Moving servers
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.
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
- AbleCommerce Admin
- Posts: 3055
- Joined: Mon Dec 01, 2003 8:41 pm
- Location: Vancouver, WA
- Contact:
Re: SQL 2000 Data to SQL 2008. Moving servers
Hello,
I don't see why 2000 to 2008 data restore would cause any issues with AbleCommerce, did you found a solution?
I don't see why 2000 to 2008 data restore would cause any issues with AbleCommerce, did you found a solution?
-
- Ensign (ENS)
- Posts: 19
- Joined: Thu Oct 29, 2009 5:34 am
Re: SQL 2000 Data to SQL 2008. Moving servers
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.
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
- Developer
- Posts: 4116
- Joined: Wed Dec 10, 2003 5:26 pm
Re: SQL 2000 Data to SQL 2008. Moving servers
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?
Cheers,
Logan
.com
If I do not respond to an unsolicited private message, it's not because I'm ignoring you. It's because the answer to your question is valuable to others. Try the new topic button.
Logan
![Image](http://forums.ablecommerce.com/a_logo_trans.gif)
If I do not respond to an unsolicited private message, it's not because I'm ignoring you. It's because the answer to your question is valuable to others. Try the new topic button.
-
- Ensign (ENS)
- Posts: 19
- Joined: Thu Oct 29, 2009 5:34 am
Re: SQL 2000 Data to SQL 2008. Moving servers
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.
If I recall it was throwing 'deadlocked' errors'. And that was when it loaded. It mostly just attempted to load.
-
- Ensign (ENS)
- Posts: 15
- Joined: Thu May 08, 2008 8:01 pm
Re: SQL 2000 Data to SQL 2008. Moving servers
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.
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.
-
- Ensign (ENS)
- Posts: 19
- Joined: Thu Oct 29, 2009 5:34 am
Re: SQL 2000 Data to SQL 2008. Moving servers
I eventually got this fixed.
Now I have to move again because I've outgrown another server.
Making the switch next week.
Now I have to move again because I've outgrown another server.
Making the switch next week.