Re: [Dev] [DEV][MB] Truncate Tables Script MSSQL
Hi, Added in my git repo[1]. [1] https://github.com/pumudu88/wso2-mb-db-scripts Regards, On Thu, Mar 26, 2015 at 10:42 AM, Ramith Jayasinghe ram...@wso2.com wrote: could you host these in your git hub then we can download it from there. On Wed, Mar 25, 2015 at 7:25 PM, Pumudu Ruhunage pum...@wso2.com wrote: 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 ram...@wso2.com wrote: shall we commit this to a scratch/personal area? On Tue, Feb 10, 2015 at 2:15 PM, Pamod Sylvester pa...@wso2.com 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 darsha...@wso2.com 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: pa...@wso2.com cell: +94 77 7779495 ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Ramith Jayasinghe Technical Lead WSO2 Inc., http://wso2.com lean.enterprise.middleware E: ram...@wso2.com P: +94 777542851 ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Pumudu Ruhunage Associate Software Engineer | WSO2 Inc M: +94 779 664493 | http://wso2.com -- Ramith Jayasinghe Technical Lead WSO2 Inc., http://wso2.com lean.enterprise.middleware E: ram...@wso2.com P: +94 777542851 -- Pumudu Ruhunage Associate Software Engineer | WSO2 Inc M: +94 779 664493 | http://wso2.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] [DEV][MB] Truncate Tables Script MSSQL
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 ram...@wso2.com wrote: shall we commit this to a scratch/personal area? On Tue, Feb 10, 2015 at 2:15 PM, Pamod Sylvester pa...@wso2.com 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 darsha...@wso2.com 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: pa...@wso2.com cell: +94 77 7779495 ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Ramith Jayasinghe Technical Lead WSO2 Inc., http://wso2.com lean.enterprise.middleware E: ram...@wso2.com P: +94 777542851 ___ Dev mailing list Dev@wso2.org 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 Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] [DEV][MB] Truncate Tables Script MSSQL
could you host these in your git hub then we can download it from there. On Wed, Mar 25, 2015 at 7:25 PM, Pumudu Ruhunage pum...@wso2.com wrote: 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 ram...@wso2.com wrote: shall we commit this to a scratch/personal area? On Tue, Feb 10, 2015 at 2:15 PM, Pamod Sylvester pa...@wso2.com 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 darsha...@wso2.com 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: pa...@wso2.com cell: +94 77 7779495 ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Ramith Jayasinghe Technical Lead WSO2 Inc., http://wso2.com lean.enterprise.middleware E: ram...@wso2.com P: +94 777542851 ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Pumudu Ruhunage Associate Software Engineer | WSO2 Inc M: +94 779 664493 | http://wso2.com -- Ramith Jayasinghe Technical Lead WSO2 Inc., http://wso2.com lean.enterprise.middleware E: ram...@wso2.com P: +94 777542851 ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] [DEV][MB] Truncate Tables Script MSSQL
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 darsha...@wso2.com 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: pa...@wso2.com cell: +94 77 7779495 ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
[Dev] [DEV][MB] Truncate Tables Script MSSQL
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* TruncateMBTablesMSSQL.sql Description: Binary data ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] [DEV][MB] Truncate Tables Script MSSQL
shall we commit this to a scratch/personal area? On Tue, Feb 10, 2015 at 2:15 PM, Pamod Sylvester pa...@wso2.com 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 darsha...@wso2.com 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: pa...@wso2.com cell: +94 77 7779495 ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Ramith Jayasinghe Technical Lead WSO2 Inc., http://wso2.com lean.enterprise.middleware E: ram...@wso2.com P: +94 777542851 ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev