Share
ReportWe would like to copy our Cashier list to a new store database. Any ideas how to do this in SQL or another method?
*This post is locked for comments
You’re offline. This is a read only version of the page.
We would like to copy our Cashier list to a new store database. Any ideas how to do this in SQL or another method?
*This post is locked for comments
If you have HQ, when you export a new store database, you select a TEMPLATE database that will copy local data, including cashiers and security settings. On your HQ Server, install Store Operations, patch it up so it matches your HQ version. Backup the SO database you wish to copy security and cashiers from; restore it on the HQ server and call that database TEMPLATE. Create the new store in HQ as you normally would, then export the new store database in HQ Admin, and select your TEMPLATE database when it prompts you to select a template; your template database should send over to your new store database cashiers and security levels, if I am not mistaken. Hope this helps
Thanks for the replies guys!
To answer your questions:
1. SQL Server Standard 2012 - Running Backwards Compatibility and Openrowset.
2. Excel 2010.
3. Two stores connected to HQ Server.
4. No we are in testing phase and will go live end of month.
Hi.
This looks easy, but can be tricky. It's not only the Cashier table, there are few issues You need to take care of, security levels defined or similar...
To be able to give you a better answer, can You give us more details on:
- version of SQL you are using
- Do You have SQL Server management studio installed on the database servers?
- Do You have MSFT Excel on the database servers and if, what version?
- this 2 stores are in HQ envoronment od individual stores without HQ?
- If you have HQ, do you have the RMS SO Master database for esporting new stores?
- Have this new store gone LIVE?
Best regards, A.
I think this is dynamic data that can't be copied using the New Store Wizard or any other in-program solution I know of, so I think you'd need to turn to SQL.
Assuming the databases are on different servers, my first thought would be to set up one store as a linked server to the other and just select from one table into another, but Jeff from Checkpoint has advised me on here in the past not to attempt linking RMS servers.
I think you would need to either employ the OPENROWSET() function in the destination database (which may require some tinkering with security settings) or export the cashiers table from the source store as a CSV and import it into a temporary table in the destination store using BULK INSERT before copying it over to the cashiers table.
#1
André Arnaud de Cal...
292,494
Super User 2025 Season 1
#2
Martin Dráb
231,305
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
