We are moving our LIVE site to a new server. I created a new install of AspDotNetStorefront and a new, empty database. My web.config file is working and I am transferring my Web files to the new site with no issues.
I am having a problem moving the databases. I thought I could just do a backup and restore on the new server - but that isn't working. SQL Express will not let me restore from a different database.
Is there a tool or script to copy data from my current LIVE site and upload it to the new site?
Thanks in advance.