Clear All orders work periods etc Script

[Ali]

Hi Guys,

I had seen a script file on here to clear all history of orders on here, but i cant seem to find it.
cant you point me to the link or post the script?

Thanks

[emre]

http://forum2.sambapos.org/index.php/topic,60.msg251.html#msg251

[Ali]

thanks Emre,

I did see this but I has seen a post by JohnS where he had a script also maybe i think this was the one.

thanks again I will check this out and try to run it later and let you know the outcome.

Kind Regards.

[tonishala]

Hi there,

How do I connect the script (dtrain.sqle) on management studio?
cause im not able to execute it without being connected, im not that familiar with sql management studio,
Thanks in advance
Tony.

[emre]

when you first start management studio it should ask connection properties. You'll enter server name, user, password as you entered on SambaPOS connection.

You'll click on new query and select "sambadata2" database from the database selection combobox. You'll find it on top left toolbar.

dtran file is a txt file. You'll open it copy & paste script in management studio.

[icemax]

this a sample batch file

via command line   http://forum2.sambapos.org/index.php/topic,1303.0.html


bye