Hi, While doing mb cluster testing when i wants to start from clean database i've used attached db drop sql script with dsetup. only catch is that mssql user have to have drop/create database privileges to run this script. Make sure to changes database names if anyone using this script.
Regards, On Tue, Feb 10, 2015 at 2:16 PM, Ramith Jayasinghe <[email protected]> wrote: > shall we commit this to a scratch/personal area? > > On Tue, Feb 10, 2015 at 2:15 PM, Pamod Sylvester <[email protected]> wrote: > >> Good stuff. This will be useful when carrying out tests, so that we will >> not need to drop the DB entirely. >> >> On Tue, Feb 10, 2015 at 2:10 PM, Akalanka Pagoda Arachchi < >> [email protected]> wrote: >> >>> Hi all, >>> >>> Attached truncate tables script to be used in testing/dev when MB is >>> configured to be used with SQL Server. >>> >>> Thanks, >>> Akalanka. >>> >>> -- >>> *Darshana Akalanka Pagoda Arachchi,* >>> *Software Engineer* >>> *078-4721791 <078-4721791>* >>> >> >> >> >> -- >> *Pamod Sylvester * >> *Senior Software Engineer * >> Integration Technologies Team, WSO2 Inc.; http://wso2.com >> email: [email protected] cell: +94 77 7779495 >> >> _______________________________________________ >> Dev mailing list >> [email protected] >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > > > -- > Ramith Jayasinghe > Technical Lead > WSO2 Inc., http://wso2.com > lean.enterprise.middleware > > E: [email protected] > P: +94 777542851 > > > _______________________________________________ > Dev mailing list > [email protected] > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- Pumudu Ruhunage Associate Software Engineer | WSO2 Inc M: +94 779 664493 | http://wso2.com
mssql_db_drop.sql
Description: Binary data
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
