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.

Database copy and synchronisation

3 posts in General Discussion Last posting was on 2009-09-03 03:19:26.0Z
MusilDavid Posted on 2009-09-02 04:34:28.0Z
From: MusilDavid@seznam.cz
Newsgroups: sybase.public.ase.general
Subject: Database copy and synchronisation
Date: Tue, 1 Sep 2009 21:34:28 -0700 (PDT)
Organization: http://groups.google.com
Lines: 15
Message-ID: <3f309375-5f21-42af-b55b-f76a78d174be@y42g2000yqb.googlegroups.com>
NNTP-Posting-Host: 85.207.239.123
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: posting.google.com 1251866068 26957 127.0.0.1 (2 Sep 2009 04:34:28 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 2 Sep 2009 04:34:28 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: y42g2000yqb.googlegroups.com; posting-host=85.207.239.123; posting-account=X8MzOQoAAAACEFP5xycLFq8v1f8-X4yk
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; Trident/4.0; GTB6; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!newsfeed.news2me.com!nx01.iad01.newshosting.com!newshosting.com!198.186.194.250.MISMATCH!news-xxxfer.readnews.com!news-out.readnews.com!transit4.readnews.com!postnews.google.com!y42g2000yqb.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28262
Article PK: 77506

Hello,

I would like to run copy of my original databse to notebook for
presentations and do update this small copy of database from time to
time, so:

1) I would like to copy db structures (tables, trigger etc) to another
(now empty) db - is there any rapid solution?

2) I would like to synchronise these structures from time to time

3) I would like to fill up this copy with some pattern (just small) of
data

Thanks for advices


DavidM Posted on 2009-09-02 07:35:59.0Z
Sender: 4835.4a9e1ff3.1804289383@sybase.com
From: DavidM
Newsgroups: sybase.public.ase.general
Subject: Re: Database copy and synchronisation
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4a9e205f.4845.1681692777@sybase.com>
References: <3f309375-5f21-42af-b55b-f76a78d174be@y42g2000yqb.googlegroups.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 2 Sep 2009 00:35:59 -0700
X-Trace: forums-1-dub 1251876959 10.22.241.41 (2 Sep 2009 00:35:59 -0700)
X-Original-Trace: 2 Sep 2009 00:35:59 -0700, 10.22.241.41
Lines: 19
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28266
Article PK: 77509

Can Administrator remove my duplicate post? Thanks DavidM

> Hello,
>
> I would like to run copy of my original databse to
> notebook for presentations and do update this small copy
> of database from time to time, so:
>
> 1) I would like to copy db structures (tables, trigger
> etc) to another (now empty) db - is there any rapid
> solution?
>
> 2) I would like to synchronise these structures from time
> to time
>
> 3) I would like to fill up this copy with some pattern
> (just small) of data
>
> Thanks for advices


Jeff Tallman [Sybase] Posted on 2009-09-03 03:19:26.0Z
From: "Jeff Tallman [Sybase]" <jeff.tallman@sybase.com>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Database copy and synchronisation
References: <3f309375-5f21-42af-b55b-f76a78d174be@y42g2000yqb.googlegroups.com>
In-Reply-To: <3f309375-5f21-42af-b55b-f76a78d174be@y42g2000yqb.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a9f35be$1@forums-1-dub>
Date: 2 Sep 2009 20:19:26 -0700
X-Trace: forums-1-dub 1251947966 10.22.241.152 (2 Sep 2009 20:19:26 -0700)
X-Original-Trace: 2 Sep 2009 20:19:26 -0700, vip152.sybase.com
Lines: 34
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28269
Article PK: 77512

2 Options:

1 - Use DDLGEN (via Sybase Central) to reverse the schema....keep in
sync manually.

2 - Each license of ASE Enterprise Edition typically includes a single
copy/license of PowerDesigner Physical Modeler - included on the PC
Client CD. Make sure no one else is using/installed the PD component
and then simply install on your laptop. Not only can this reverse
engineer the schema, but it can also do schema diffs - and once you
learn to use it, you will likely do all your data modeling there as it
can generate catchup scripts, etc.

Jeff Tallman
Enterprise Data Management Products Technical Evangelism
jeff.tallman@sybase.com
http://blogs.sybase.com/database

MusilDavid@seznam.cz wrote:
> Hello,
>
> I would like to run copy of my original databse to notebook for
> presentations and do update this small copy of database from time to
> time, so:
>
> 1) I would like to copy db structures (tables, trigger etc) to another
> (now empty) db - is there any rapid solution?
>
> 2) I would like to synchronise these structures from time to time
>
> 3) I would like to fill up this copy with some pattern (just small) of
> data
>
> Thanks for advices