Export Store Database

(0) Share

Report

Posted on by Community Member

Hi,

We have problem exporting store database from RMS (1006) and SQL 2012 64 working at Windows server 2008 Enterprise 64 sp2.

when try to create new store database, it just copy the template database with all fields like purchseorder and [transaction] even configuration (storeid). the you just another copy of your template.

now after restoring the sample HQ and store databases from "dbfiles" and do create new store and export, found the same problem.

the problem shows at the attached image when click ok, it should start scripting the template store and show progress bar. but when click ok it just show the next step and ignore scripting without any progress shown

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

We need to know which version of HQ and RMS you are running. Some older versions to not support SQL 2012

Was this reply helpful? Yes No
Jeff @ Check Point ... 13,382 on at

Like (0)

Report
Copy link

Link copied!

Pretty sure this is a SQL2k12 issue. Try backing down to SQL2k8.

FWIW, we are holding off using SQL2k12 because of weirdness issues.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Ed,

Thanks for your reply, I'm using 2.0.1006.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Jeff,

Thanks for your reply, but it this the only way?, how long do you think RMS will start support SQL2012?

but they Microsoft did issue that it support SQL2012 for RMS2

https://el3rod.com

Was this reply helpful? Yes No
Jeff @ Check Point ... 13,382 on at

Like (0)

Report
Copy link

Link copied!

Well, they claim to support it now, but we've seen weird things happening, so we are not installing it on any of our client's machines right now.

Sticking with Sk8R2.

Since this appears to be a test machine or VM, should be easy enough to try with an earlier version

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Jeff,

Thanks, but I'm working with SQL2012 for over a month ago at my stores and didnot see any problem except the export, would you please till me about some of those problems that you faced to check that at my side.

Thanks again

Was this reply helpful? Yes No
miguelgandia 5 on at

Like (0)

Report
Copy link

Link copied!

Hi Mohammed,

I have this same error. This was solved?

Regards,

Miguel

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

you can also try mirroring DB/replication to SQL 2012 if you REALLY need 2012.

I would wait, RMS will phase out within 12 months to new stuff like cloud HQ @ MSFT direct...so no more problems with HQ infrastructure..

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi EkQadi,

Didn you find any solution for this ? We are facing exactly the same issue while exporting the database ? SQL 2012 is supported in RMS CU5 as per the tech notes but it doesn't work. Template DB is not scripting instead it goes to next screen and start coping the template database data into new database. any suggestions would be appreciated...

Regards

GA

Was this reply helpful? Yes No
Mohammed ElQadi 132 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Just use SQL2008.

Was this reply helpful? Yes No