Unclear on how to upgrade AC MSSQL DB

[southside2005]

My current store is running as follows on DEV machine:
Version: 7.0.3
Build: 12458
MSSQL: v2000
AC SCHEMA: v2000

I wish to upgrade to 7.0.4 and MSSQL 2008. I have MSSQL 2008 installed on my LIVE sever and have full admin access to that server.

If I simply do a db restore into MSSQL 2008 won't that still be using the AC SCHEMA for v2000?

I feel like I'm missing a piece of the puzzle, or step or script I have to run to modify my DB for the new version.

Any direction would be greatly appreciated.

[mazhar]

Please have a look at following thread
viewtopic.php?f=42&t=12808

[mazhar]

Also here is topic about moving from Dev to live environment this may help you as well
http://wiki.ablecommerce.com/index.php/ ... _Live_site

[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.