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.

Move tables, development to production

4 posts in Trigger Last posting was on 2005-02-11 22:23:54.0Z
Michael Posted on 2005-01-31 15:40:54.0Z
Reply-To: "Michael" <mawoodard@pilotcat.com>
From: "Michael" <mawoodard@pilotcat.com>
Newsgroups: advantage.trigger
Subject: Move tables, development to production
Date: Mon, 31 Jan 2005 09:40:54 -0600
Lines: 13
Organization: Pilot
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: 12.6.72.4
Message-ID: <41fe525c@solutions.advantagedatabase.com>
X-Trace: 31 Jan 2005 08:44:28 -0700, 12.6.72.4
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!12.6.72.4
Xref: solutions.advantagedatabase.com Advantage.Trigger:143
Article PK: 1136209

Hello All,

I have created some tables in our test DB and now need to move them to our
production DB. By just moving the tables in the past I have had to re-create
the TRIGGERS. Does any know of a technique to move the TRIGGERS along with
the tables? I am thinking I need to extract or copy my trigger definitions
from the systems tables of the test DB to prodution DB.

Thanks in advance for your help!

Michael Woodard


J.D. Mullin Posted on 2005-01-31 23:59:46.0Z
Message-ID: <28342632427873600846432@devzone.advantagedatabase.com>
From: J.D. Mullin <no@email.com>
Subject: Re: Move tables, development to production
Newsgroups: Advantage.Trigger
References: <41fe525c@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Reader 381.17
NNTP-Posting-Host: 198.102.102.75
Date: 31 Jan 2005 16:59:46 -0700
X-Trace: 31 Jan 2005 16:59:46 -0700, 198.102.102.75
Lines: 21
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!198.102.102.75
Xref: solutions.advantagedatabase.com Advantage.Trigger:144
Article PK: 1136210

You can right-click on the table in arc and select "generate sql", then run
that script on the production db.

J.D. Mullin
Advantage R&D

> Hello All,
>
> I have created some tables in our test DB and now need to move them to
> our production DB. By just moving the tables in the past I have had to
> re-create the TRIGGERS. Does any know of a technique to move the
> TRIGGERS along with the tables? I am thinking I need to extract or
> copy my trigger definitions from the systems tables of the test DB to
> prodution DB.
>
> Thanks in advance for your help!
>
> Michael Woodard
>


Michael Woodard Posted on 2005-02-11 20:00:37.0Z
Reply-To: "Michael Woodard" <mawoodard@pilotcat.com>
From: "Michael Woodard" <mawoodard@pilotcat.com>
Newsgroups: Advantage.Trigger
References: <41fe525c@solutions.advantagedatabase.com> <28342632427873600846432@devzone.advantagedatabase.com>
Subject: Re: Move tables, development to production
Date: Fri, 11 Feb 2005 14:00:37 -0600
Lines: 32
Organization: Pilot
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: 12.6.72.4
Message-ID: <420d0fe8@solutions.advantagedatabase.com>
X-Trace: 11 Feb 2005 13:04:56 -0700, 12.6.72.4
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!12.6.72.4
Xref: solutions.advantagedatabase.com Advantage.Trigger:149
Article PK: 1136217

Thanks JD Mullin,

When attempt to generate the SQL I get a blank Output Code window. I am
using Advantge 7.1 on a Wnidows XP workstation, any ideas?

Michael Woodard

"J.D. Mullin" <no@email.com> wrote in message
news:28342632427873600846432@devzone.advantagedatabase.com...
> You can right-click on the table in arc and select "generate sql", then
run
> that script on the production db.
>
> J.D. Mullin
> Advantage R&D
>
> > Hello All,
> >
> > I have created some tables in our test DB and now need to move them to
> > our production DB. By just moving the tables in the past I have had to
> > re-create the TRIGGERS. Does any know of a technique to move the
> > TRIGGERS along with the tables? I am thinking I need to extract or
> > copy my trigger definitions from the systems tables of the test DB to
> > prodution DB.
> >
> > Thanks in advance for your help!
> >
> > Michael Woodard
> >
>
>