Moving Installation to a New Server

[Psalty]

Hello,

We are currently on Ablecommerce 7.0.4 Build 14026.

We would like to move our installation to a new server.

Old Server
Window 2003
SQL Server 2005

New Server
Windows 2008 R2
SQL Server 2008 R2

From what I've read in the forums, this sounds like it should be pretty simple. Move the files and db. Install the new license. Back up and restore the encryption. Is there anything else I should be considering? Is SQL Server 2008 R2 compatible with 7.0.4? Also, we are thinking of setting up merge replication between the new SQL instance and a DB at our home office. Merge replication adds a rowguid to all replicated tables. Will this change to the schema cause any problems with Able?

Thanks!
Chuck

[david-ebt]

If your site configuration is the same between the old server and the new server then the move should just be move the files and DB as you've noted. It becomes a bit more challenging if you're changing the store URL (like moving from a dev server to a live server). In case you haven't seen this, there's an article on the AC wiki about moving from DEV to LIVE.

http://wiki.ablecommerce.com/index.php/ ... _Live_site

I've not had any experience changing the AC data table structure so I'm not sure how the additional field would affect the site. Adding columns can sometimes be a problem if the INSERT statements don't account for the new fields properly. But I'm guessing the rowguid has a default value which should make it okay. Can you set up a development/test environment?

[dgoranov]

Merge replication may add additional load on your mssql server, but other than that it should work if setup properly. The only other setting you may have to double check is
site asp.net application pool -> Advanced Settings -> Enable 32bit Applications set to True