New Theme/Database

I have an existing website running 3.5 which is working fine. I purchased one of the nopCommerce templates and installed it, but some of the plugins were corrupted. So I installed the new template in a temporary web space in a new database so I could make sure everything worked.

Now that everything is working, I just need to transfer the customer and order info from our live site to the new database with the template. Both databases are ver 3.5, but when I tried to run a generated script, I got a bunch of errors like the following:

Msg 2714, Level 16, State 6, Line 1
There is already an object named 'Customer' in the database.

Does anyone know how I can accomplish this?
Thanks

Jim

Hi Jim,
Seems like when you generated a script it was added to create a table Customers.
I'd suggest you go to the old website, admin and export customers and orders then simple import this data into your new website.

Thanks,
Alex

jimkoh wrote:

Hi Jim,

You just need to transfer the data not to create a new table with data. You might need to customize your script to achieve the desired results. There are many options to do this.. but make sure you do proper mapping!