Clear all the sybase DB

[SoTelecom]

Hi Link
I want to give a congratulation about the excelent job, you are currently doing, with this forum. I think there are a lot of people who need some litle help.

I'd like you can give us the shell promised by you in post :http://www.voip-expert.com/modules/forum/viewtopic.php?t=440&highlight=bcp

I'd like you can send some info, for empty the DB, we want to start with VM, without old data ( account, cdr, logs, etc )
is there nay way to do that ?

Regards

Sotelecom

[Link]

Thank you SoTelecom ;)
Peoples require some certain functionality from software for their bussines, so my goal is to help with your bussines

to clear DB you have to execure stored procedure sp_clear_db
this won't delete every table, but only all table with work data, and leave system tables untouched (where stored system types, options etc..)

To execute it - you have to login to DB from console for example
isql -Umanager -Ppassword -SIFONE

exec sp_clear_db
go

be sure you do not need any data , they will will be backuped during one day, untill backup will be overwriten

let me know if you have problems with executing this procedure
_________________
Easy must be easy, and difficult - possible!
ask for ensure -yuriy AT voip-experts DOT com

[Neo]

Hi .
Absolutly right, sp_clear_db was created for older VM version (like 02.00 or even older), it clears only part of tables in new VM version, unexpected results will happen

I have created sp_clear_daabase procedure for 06.00 since I need often to clear DB in my work. msg me , will share
_________________
free your mind