Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Version Control for stored procedures, triggers etc.,

3 posts in XML Last posting was on 2003-04-16 10:48:16.0Z
Karthik Posted on 2003-04-15 21:16:51.0Z
Newsgroups: sybase.public.powerbuilder.xml
Reply-To: "Karthik" <kpanc@laborfinders.com>
From: "Karthik" <kpanc@laborfinders.com>
Subject: Version Control for stored procedures, triggers etc.,
Date: Tue, 15 Apr 2003 17:16:51 -0400
Lines: 15
Organization: Labor Finders Inc.
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
NNTP-Posting-Host: 63.98.11.66
Message-ID: <373_#Uk2AS5ADHA.200@forums-2-dub>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.xml:24
Article PK: 813100

Hi,

We are using PB 7.0.5. For version control we are using Microsoft
Visualsourcesafe to manage the PB objects by check-In and check-out. Where
as we dont have any version control for our Back end stored procedures,
functions, triggers. Is there anyone know about version control for this
back end files. So that it will be in a organized manner for our
application.

Any hint will be appreciated

Thanks
Karthik


Biju Nair Posted on 2003-04-15 21:38:27.0Z
Newsgroups: sybase.public.powerbuilder.xml
From: "Biju Nair" <bijurk@hotmail.com>
Subject: Re: Version Control for stored procedures, triggers etc.,
Date: Tue, 15 Apr 2003 16:38:27 -0500
Lines: 41
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: host37.kingswayit.com 208.255.221.37
Message-ID: <373_#$5P8e5ADHA.221@forums-1-dub>
References: <373_#Uk2AS5ADHA.200@forums-2-dub>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums-1-dub.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.xml:25
Article PK: 813097

Karthik,

Wrong forum! To get a better response, post this in the Source
Control/Database forums

We used to use the same source control for Database as well as
PowerBuilder...
Open the script of the Database object, save as a text file (with some
standard extensions like .tbl for table, .trg for trigger etc.) and add it
in a separate directories for each type of objects in your source control
server.

To enforce version control, allow the person (very often the DBA) who
executes the scripts to get it only from a new revision in the source
control!

Some back-end tools like Embarcadero's Rapid SQL/DBArtisan support source
control...
I do not know the details of those however...

Cheers,
Biju

"Karthik" <kpanc@laborfinders.com> wrote in message
news:#Uk2AS5ADHA.200@forums-2-dub...
> Hi,
>
> We are using PB 7.0.5. For version control we are using Microsoft
> Visualsourcesafe to manage the PB objects by check-In and check-out. Where
> as we dont have any version control for our Back end stored procedures,
> functions, triggers. Is there anyone know about version control for this
> back end files. So that it will be in a organized manner for our
> application.
>
> Any hint will be appreciated
>
> Thanks
> Karthik
>
>


Michael Kramer Posted on 2003-04-16 10:48:16.0Z
Newsgroups: sybase.public.powerbuilder.xml
From: "Michael Kramer" <mkramer@sybase.com.nospam>
Subject: Re: Version Control for stored procedures, triggers etc.,
Date: Wed, 16 Apr 2003 12:48:16 +0200
Lines: 28
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: vpn-uk-020.sybase.com 158.76.101.20
Message-ID: <373_#6yLUYABDHA.303@forums-1-dub>
References: <373_#Uk2AS5ADHA.200@forums-2-dub>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums-1-dub.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.xml:26
Article PK: 813102

PowerBuilder XML isn't the right forum. Anyway: PowerDesigner lets you do
the tasks you ask for. Also PowerDesigner has a repository that lets you do
version control. Any questions regarding PowerDesigner should go to the
powersoft.public.powerdesigner.general newsgroup.

HTH
/MicK
Michael Kramer, Sybase Danmark

"Karthik" <kpanc@laborfinders.com> wrote in message
news:#Uk2AS5ADHA.200@forums-2-dub...
> Hi,
>
> We are using PB 7.0.5. For version control we are using Microsoft
> Visualsourcesafe to manage the PB objects by check-In and check-out. Where
> as we dont have any version control for our Back end stored procedures,
> functions, triggers. Is there anyone know about version control for this
> back end files. So that it will be in a organized manner for our
> application.
>
> Any hint will be appreciated
>
> Thanks
> Karthik
>
>