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.

Duplicate (synchronize) table data to another table

8 posts in ,  Product Futures DiscussionGeneral DiscussionBackup and Recovery Administration Last posting was on 2002-03-05 02:54:11.0Z
GC Posted on 2002-01-28 19:27:35.0Z
Reply-To: "GC" <guillermo@e-nablercorp.com>
From: "GC" <guillermo@e-nablercorp.com>
Subject: Duplicate (synchronize) table data to another table
Date: Mon, 28 Jan 2002 15:27:35 -0400
Lines: 14
Organization: E-Nabler Corporation
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <lr1L9LDqBHA.222@forums.sybase.com>
Newsgroups: sybase.public.ase.administration,sybase.public.ase.backup+recovery,sybase.public.ase.general,sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: unknown.Level3.net 64.152.137.226
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.administration:3137 sybase.public.ase.backup+recovery:232 sybase.public.ase.general:148 sybase.public.ase.product_futures_discussion:134
Article PK: 27810

Hello,
I'm looking for a way of duplicating (synchronize) data from a table in one
of my databases to another table in the same database. In other words, I
need that certain columns in the X table be synchronized every 15 minutes to
the X2 table in my database. Any idea on how to do this or an application
that allows me to do this?

Thanks
---
Guillermo Carrion
Web Developer
E-Nabler Corporation


Patrick Tahiri Posted on 2002-03-04 12:05:27.0Z
Reply-To: "Patrick Tahiri" <patrick.tahiri@telenor.com>
From: "Patrick Tahiri" <patrick.tahiri@telenor.com>
References: <lr1L9LDqBHA.222@forums.sybase.com>
Subject: Re: Duplicate (synchronize) table data to another table
Date: Mon, 4 Mar 2002 13:05:27 +0100
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <1IZPHX3wBHA.292@forums.sybase.com>
Newsgroups: sybase.public.ase.administration,sybase.public.ase.backup+recovery,sybase.public.ase.general,sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: 212.17.147.14
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.administration:3132 sybase.public.ase.backup+recovery:227 sybase.public.ase.general:143 sybase.public.ase.product_futures_discussion:129
Article PK: 27805

Hi,

You can also create a trigger!!! Each time an update (insert) occur on table
A it will update (synchronize) table B!!

Patrick.

"GC" <guillermo@e-nablercorp.com> wrote in message
news:lr1L9LDqBHA.222@forums.sybase.com...
> Hello,
> I'm looking for a way of duplicating (synchronize) data from a table in
one
> of my databases to another table in the same database. In other words, I
> need that certain columns in the X table be synchronized every 15 minutes
to
> the X2 table in my database. Any idea on how to do this or an application
> that allows me to do this?
>
> Thanks
> ---
> Guillermo Carrion
> Web Developer
> E-Nabler Corporation
>
>


gongyongxing Posted on 2002-03-05 02:54:11.0Z
From: "gongyongxing" <gyx@sina.com>
References: <lr1L9LDqBHA.222@forums.sybase.com> <1IZPHX3wBHA.292@forums.sybase.com>
Subject: Re: Duplicate (synchronize) table data to another table
Date: Tue, 5 Mar 2002 10:54:11 +0800
Lines: 39
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2615.200
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
Message-ID: <0FbUTH$wBHA.319@forums.sybase.com>
Newsgroups: sybase.public.ase.administration
NNTP-Posting-Host: 202.107.220.9
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.administration:5916
Article PK: 22451

Hi,
You man get it by the cron in Unix ,by the 'at' in NT with scripts.
BTW , who don't you just create a view ?

Patrick Tahiri <patrick.tahiri@telenor.com> wrote in message
news:1IZPHX3wBHA.292@forums.sybase.com...
> Hi,
>
> You can also create a trigger!!! Each time an update (insert) occur on
table
> A it will update (synchronize) table B!!
>
> Patrick.
>
> "GC" <guillermo@e-nablercorp.com> wrote in message
> news:lr1L9LDqBHA.222@forums.sybase.com...
> > Hello,
> > I'm looking for a way of duplicating (synchronize) data from a table in
> one
> > of my databases to another table in the same database. In other words, I
> > need that certain columns in the X table be synchronized every 15
minutes
> to
> > the X2 table in my database. Any idea on how to do this or an
application
> > that allows me to do this?
> >
> > Thanks
> > ---
> > Guillermo Carrion
> > Web Developer
> > E-Nabler Corporation
> >
> >
>
>


Jim Egan Posted on 2002-01-29 03:48:46.0Z
From: Jim Egan <dontspam.dbaguru@eganomics.com>
Subject: Re: Duplicate (synchronize) table data to another table
Date: Mon, 28 Jan 2002 20:48:46 -0700
Message-ID: <MPG.16bfc98acbae88f98ba46@forums.sybase.com>
References: <lr1L9LDqBHA.222@forums.sybase.com>
Reply-To: eganjp@compuserve.com
X-Newsreader: MicroPlanet Gravity v2.50
Newsgroups: sybase.public.ase.administration,sybase.public.ase.backup+recovery,sybase.public.ase.general,sybase.public.ase.product_futures_discussion
Lines: 19
NNTP-Posting-Host: 12-252-108-115.client.attbi.com 12.252.108.115
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.administration:3133 sybase.public.ase.backup+recovery:228 sybase.public.ase.general:144 sybase.public.ase.product_futures_discussion:130
Article PK: 27807


guillermo@e-nablercorp.com wrote...
> Hello,
> I'm looking for a way of duplicating (synchronize) data from a table in one
> of my databases to another table in the same database. In other words, I
> need that certain columns in the X table be synchronized every 15 minutes to
> the X2 table in my database. Any idea on how to do this or an application
> that allows me to do this?

Please do not cross post messages. I will delete future messages that do this.

IMO, this would be a simple thing to do using a trigger. That way it is basically real
time and you don't have to wait 15 minutes for the data to be up to date.
--
Jim Egan [TeamSybase]
Senior Consultant
Sybase Professional Services


Germano Posted on 2002-01-28 19:57:32.0Z
From: "Germano" <Germano_Silva@Brown.edu>
References: <lr1L9LDqBHA.222@forums.sybase.com>
Subject: Re: Duplicate (synchronize) table data to another table
Date: Mon, 28 Jan 2002 14:57:32 -0500
Lines: 24
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <mOSCvZDqBHA.222@forums.sybase.com>
Newsgroups: sybase.public.ase.administration,sybase.public.ase.backup+recovery,sybase.public.ase.general,sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: 128.148.240.101
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.administration:3136 sybase.public.ase.backup+recovery:231 sybase.public.ase.general:147 sybase.public.ase.product_futures_discussion:133
Article PK: 27808

As long as you can determine what has changes in X since the last time you
have updated X2, why not write a stored procedure that will run every 15
minutes to update X2 from X

"GC" <guillermo@e-nablercorp.com> wrote in message
news:lr1L9LDqBHA.222@forums.sybase.com...
> Hello,
> I'm looking for a way of duplicating (synchronize) data from a table in
one
> of my databases to another table in the same database. In other words, I
> need that certain columns in the X table be synchronized every 15 minutes
to
> the X2 table in my database. Any idea on how to do this or an application
> that allows me to do this?
>
> Thanks
> ---
> Guillermo Carrion
> Web Developer
> E-Nabler Corporation
>
>


GC Posted on 2002-01-28 20:29:26.0Z
Reply-To: "GC" <guillermo@e-nablercorp.com>
From: "GC" <guillermo@e-nablercorp.com>
References: <lr1L9LDqBHA.222@forums.sybase.com> <mOSCvZDqBHA.222@forums.sybase.com>
Subject: Re: Duplicate (synchronize) table data to another table
Date: Mon, 28 Jan 2002 16:29:26 -0400
Lines: 40
Organization: E-Nabler Corporation
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <LihehuDqBHA.244@forums.sybase.com>
Newsgroups: sybase.public.ase.administration,sybase.public.ase.backup+recovery,sybase.public.ase.general,sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: unknown.Level3.net 64.152.137.226
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.administration:3135 sybase.public.ase.backup+recovery:230 sybase.public.ase.general:146 sybase.public.ase.product_futures_discussion:132
Article PK: 27809

Hello,
And how can I do that?

Thanks
---
Guillermo Carrion
Web Developer
E-Nabler Corporation

"Germano" <Germano_Silva@Brown.edu> wrote in message
news:mOSCvZDqBHA.222@forums.sybase.com...
> As long as you can determine what has changes in X since the last time you
> have updated X2, why not write a stored procedure that will run every 15
> minutes to update X2 from X
>
> "GC" <guillermo@e-nablercorp.com> wrote in message
> news:lr1L9LDqBHA.222@forums.sybase.com...
> > Hello,
> > I'm looking for a way of duplicating (synchronize) data from a table in
> one
> > of my databases to another table in the same database. In other words, I
> > need that certain columns in the X table be synchronized every 15
minutes
> to
> > the X2 table in my database. Any idea on how to do this or an
application
> > that allows me to do this?
> >
> > Thanks
> > ---
> > Guillermo Carrion
> > Web Developer
> > E-Nabler Corporation
> >
> >
>
>


Germano Posted on 2002-01-28 20:44:10.0Z
From: "Germano" <Germano_Silva@Brown.edu>
References: <lr1L9LDqBHA.222@forums.sybase.com> <mOSCvZDqBHA.222@forums.sybase.com> <LihehuDqBHA.244@forums.sybase.com>
Subject: Re: Duplicate (synchronize) table data to another table
Date: Mon, 28 Jan 2002 15:44:10 -0500
Lines: 54
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <SoloyzDqBHA.222@forums.sybase.com>
Newsgroups: sybase.public.ase.administration,sybase.public.ase.backup+recovery,sybase.public.ase.general,sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: 128.148.240.101
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.administration:3134 sybase.public.ase.backup+recovery:229 sybase.public.ase.general:145 sybase.public.ase.product_futures_discussion:131
Article PK: 27806

Once you write the stored procedure that will update X2 from X with the
proper insert / update / delete commands, just write a UNIX shell script
that will call the stored procedure every 15 minutes. The shell script
itself gets executed from a cron job. If you are on NT, I'm not sure if NT
as a scheduling utility, but I'm sure there must be something out there.

"GC" <guillermo@e-nablercorp.com> wrote in message
news:LihehuDqBHA.244@forums.sybase.com...
> Hello,
> And how can I do that?
>
> Thanks
> ---
> Guillermo Carrion
> Web Developer
> E-Nabler Corporation
>
>
> "Germano" <Germano_Silva@Brown.edu> wrote in message
> news:mOSCvZDqBHA.222@forums.sybase.com...
> > As long as you can determine what has changes in X since the last time
you
> > have updated X2, why not write a stored procedure that will run every 15
> > minutes to update X2 from X
> >
> > "GC" <guillermo@e-nablercorp.com> wrote in message
> > news:lr1L9LDqBHA.222@forums.sybase.com...
> > > Hello,
> > > I'm looking for a way of duplicating (synchronize) data from a table
in
> > one
> > > of my databases to another table in the same database. In other words,
I
> > > need that certain columns in the X table be synchronized every 15
> minutes
> > to
> > > the X2 table in my database. Any idea on how to do this or an
> application
> > > that allows me to do this?
> > >
> > > Thanks
> > > ---
> > > Guillermo Carrion
> > > Web Developer
> > > E-Nabler Corporation
> > >
> > >
> >
> >
>
>


Pablo Sanchez Posted on 2002-01-28 20:39:15.0Z
From: "Pablo Sanchez" <pablo@dev.null>
References: <lr1L9LDqBHA.222@forums.sybase.com> <mOSCvZDqBHA.222@forums.sybase.com> <LihehuDqBHA.244@forums.sybase.com>
Subject: Re: Duplicate (synchronize) table data to another table
Date: Mon, 28 Jan 2002 13:39:15 -0700
Lines: 21
Organization: High-Performance Database Engineering
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <jryDhyDqBHA.222@forums.sybase.com>
Newsgroups: sybase.public.ase.general
NNTP-Posting-Host: 207.225.105.222
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.general:5942
Article PK: 54218

[ removing unnecessary news groups ]

"GC" <guillermo@e-nablercorp.com> wrote in message
news:LihehuDqBHA.244@forums.sybase.com...
> Hello,
> And how can I do that?

You can write either a stored procedure or a trigger -- if you wanted
it 'sorta' real time.

Asking how to write a stored procedure is a bit out of the scope of
this newsgroup. Your best bet is to visit the online Sybase docs and
see some examples.
--
Pablo Sanchez, High-Performance Database Engineering
www.hpdbe.com
Independent Contractor, available for short-term and long-term
contracts