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.

CREATE DATABASE ...

6 posts in Product Futures Discussion Last posting was on 2008-03-13 13:20:18.0Z
renzo.aquino Posted on 2008-02-13 02:32:52.0Z
From: Renzo.aquino@gmail.com
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: CREATE DATABASE ...
Date: Tue, 12 Feb 2008 18:32:52 -0800 (PST)
Organization: http://groups.google.com
Lines: 23
Message-ID: <c0cf3381-b2f4-4334-a6ee-c0e34fee6517@p69g2000hsa.googlegroups.com>
NNTP-Posting-Host: 203.177.16.66
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1202869972 20344 127.0.0.1 (13 Feb 2008 02:32:52 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 13 Feb 2008 02:32:52 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: p69g2000hsa.googlegroups.com; posting-host=203.177.16.66; posting-account=tGPBogoAAADskRZsAjqsJ5xZWzZ8rxax
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.12) Gecko/20080201 Firefox/2.0.0.12,gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!newsfeed2.dallas1.level3.net!news.level3.com!postnews.google.com!p69g2000hsa.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1959
Article PK: 97564

As a DBA I have a horrible experience of creating a test db from a
production copy. Out of 5000+ stored procedures there were 200 of
these with #temp table dependencies either this was created from the
applications or from the parent stored procedures. Rebuilding this
#temp table was painstaking because the developer did not leave any
trace how these tables was created. I have to look at each
applications source codes and some of them are already a legacy with
only the exe available.

I wish Sybase will have a new feature in creating a test
database copy from another db source were the only missing part is the
data.

Like:

create database testdb on dev1=### log on log1=## using proddb except
data

Somebody might say... well why not load a backup copy and then
truncate the tables. Well, this is possible if your prod db is less
than 300GB

Thanks..


Jeff Tallman Posted on 2008-02-14 02:32:16.0Z
From: Jeff Tallman <jeff.tallman@sybase.com>
User-Agent: Thunderbird 2.0.0.9 (Windows/20071031)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Re: CREATE DATABASE ...
References: <c0cf3381-b2f4-4334-a6ee-c0e34fee6517@p69g2000hsa.googlegroups.com>
In-Reply-To: <c0cf3381-b2f4-4334-a6ee-c0e34fee6517@p69g2000hsa.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: <47b3a830$1@forums-1-dub>
Date: 13 Feb 2008 18:32:16 -0800
X-Trace: forums-1-dub 1202956336 10.22.241.152 (13 Feb 2008 18:32:16 -0800)
X-Original-Trace: 13 Feb 2008 18:32:16 -0800, vip152.sybase.com
Lines: 26
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1960
Article PK: 97567

Did you try sybmigrate???

Renzo.aquino@gmail.com wrote:
> As a DBA I have a horrible experience of creating a test db from a
> production copy. Out of 5000+ stored procedures there were 200 of
> these with #temp table dependencies either this was created from the
> applications or from the parent stored procedures. Rebuilding this
> #temp table was painstaking because the developer did not leave any
> trace how these tables was created. I have to look at each
> applications source codes and some of them are already a legacy with
> only the exe available.
>
> I wish Sybase will have a new feature in creating a test
> database copy from another db source were the only missing part is the
> data.
>
> Like:
>
> create database testdb on dev1=### log on log1=## using proddb except
> data
>
> Somebody might say... well why not load a backup copy and then
> truncate the tables. Well, this is possible if your prod db is less
> than 300GB
>
> Thanks..


renzo.aquino Posted on 2008-02-14 08:01:10.0Z
From: Renzo.aquino@gmail.com
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Re: CREATE DATABASE ...
Date: Thu, 14 Feb 2008 00:01:10 -0800 (PST)
Organization: http://groups.google.com
Lines: 42
Message-ID: <27d63109-6d61-481a-8ccd-bb727ead03eb@n19g2000hsd.googlegroups.com>
References: <c0cf3381-b2f4-4334-a6ee-c0e34fee6517@p69g2000hsa.googlegroups.com> <47b3a830$1@forums-1-dub>
NNTP-Posting-Host: 203.177.16.66
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1202976070 13917 127.0.0.1 (14 Feb 2008 08:01:10 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 14 Feb 2008 08:01:10 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: n19g2000hsd.googlegroups.com; posting-host=203.177.16.66; posting-account=tGPBogoAAADskRZsAjqsJ5xZWzZ8rxax
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.12) Gecko/20080201 Firefox/2.0.0.12,gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!newsfeed2.dallas1.level3.net!news.level3.com!postnews.google.com!n19g2000hsd.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1961
Article PK: 97566

What I was concerned for is the stored procedure created this way:

create table #temp(userid_cd char(10),crdate datetime)
go
create proc getuserid
as
declare @uid char(10),@crdate datetime
select @uid=userid_cd,@crdate=crdate from #temp
...
go

I know sybmigrate relies on the UTIL DDLGEN and DDLGEN does not create
a temp tables for you. Does sybmigrate do it?

On Feb 14, 10:32 am, Jeff Tallman <jeff.tall...@sybase.com> wrote:
> Did you try sybmigrate???
>
> Renzo.aqu...@gmail.com wrote:
> > As a DBA I have a horrible experience of creating a test db from a
> > production copy. Out of 5000+ stored procedures there were 200 of
> > these with #temp table dependencies either this was created from the
> > applications or from the parent stored procedures. Rebuilding this
> > #temp table was painstaking because the developer did not leave any
> > trace how these tables was created. I have to look at each
> > applications source codes and some of them are already a legacy with
> > only the exe available.
>
> > I wish Sybase will have a new feature in creating a test
> > database copy from another db source were the only missing part is the
> > data.
>
> > Like:
>
> > create database testdb on dev1=### log on log1=## using proddb except
> > data
>
> > Somebody might say... well why not load a backup copy and then
> > truncate the tables. Well, this is possible if your prod db is less
> > than 300GB
>
> > Thanks..


Lindsey Posted on 2008-03-13 13:20:18.0Z
Sender: 5711.47d928af.1804289383@sybase.com
From: Lindsey
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Re: CREATE DATABASE ...
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <47d92a11.5741.1681692777@sybase.com>
References: <27d63109-6d61-481a-8ccd-bb727ead03eb@n19g2000hsd.googlegroups.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 13 Mar 2008 05:20:18 -0800
X-Trace: forums-1-dub 1205414418 10.22.241.41 (13 Mar 2008 05:20:18 -0800)
X-Original-Trace: 13 Mar 2008 05:20:18 -0800, 10.22.241.41
Lines: 52
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1964
Article PK: 97569

I usually have whoever writes the proc to embed the create
temp table in a comment right after the 'begin' statement.
Then it is a copy & paste thing when the proc fails to
create due to #temp table not found. Still not automagic,
but the same situation exists where I used to work and the
temp table ddl will at least stay pinned to the procedure.

> What I was concerned for is the stored procedure created
> this way:
>
> create table #temp(userid_cd char(10),crdate datetime)
> go
> create proc getuserid
> as
> declare @uid char(10),@crdate datetime
> select @uid=userid_cd,@crdate=crdate from #temp
> ...
> go
>
> I know sybmigrate relies on the UTIL DDLGEN and DDLGEN
> does not create a temp tables for you. Does sybmigrate do
> it?
>
> On Feb 14, 10:32 am, Jeff Tallman
> > <jeff.tall...@sybase.com> wrote: Did you try
> sybmigrate??? >
> > Renzo.aqu...@gmail.com wrote:
> > > As a DBA I have a horrible experience of creating a
> > > test db from a production copy. Out of 5000+ stored
> > > procedures there were 200 of these with #temp table
> > > dependencies either this was created from the
> applications or from the parent stored procedures.
> > > Rebuilding this #temp table was painstaking because
> > > the developer did not leave any trace how these tables
> > > was created. I have to look at each applications
> > > source codes and some of them are already a legacy
> with only the exe available. >
> > > I wish Sybase will have a new feature in
> > > creating a test database copy from another db source
> > > were the only missing part is the data.
> >
> > > Like:
> >
> > > create database testdb on dev1=### log on log1=##
> > > using proddb except data
> >
> > > Somebody might say... well why not load a backup copy
> > > and then truncate the tables. Well, this is possible
> > > if your prod db is less than 300GB
> >
> > > Thanks..
>


Carl Kayser Posted on 2008-03-07 17:37:42.0Z
From: "Carl Kayser" <kayser_c@bls.gov>
Newsgroups: sybase.public.ase.product_futures_discussion
References: <c0cf3381-b2f4-4334-a6ee-c0e34fee6517@p69g2000hsa.googlegroups.com>
Subject: Re: CREATE DATABASE ...
Lines: 31
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47d17d66@forums-1-dub>
Date: 7 Mar 2008 09:37:42 -0800
X-Trace: forums-1-dub 1204911462 10.22.241.152 (7 Mar 2008 09:37:42 -0800)
X-Original-Trace: 7 Mar 2008 09:37:42 -0800, vip152.sybase.com
X-Authenticated-User: ase1251
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1963
Article PK: 97568


<Renzo.aquino@gmail.com> wrote in message
news:c0cf3381-b2f4-4334-a6ee-c0e34fee6517@p69g2000hsa.googlegroups.com...
> As a DBA I have a horrible experience of creating a test db from a
> production copy. Out of 5000+ stored procedures there were 200 of
> these with #temp table dependencies either this was created from the
> applications or from the parent stored procedures. Rebuilding this
> #temp table was painstaking because the developer did not leave any
> trace how these tables was created. I have to look at each
> applications source codes and some of them are already a legacy with
> only the exe available.
>
> I wish Sybase will have a new feature in creating a test
> database copy from another db source were the only missing part is the
> data.
>
> Like:
>
> create database testdb on dev1=### log on log1=## using proddb except
> data
>
> Somebody might say... well why not load a backup copy and then
> truncate the tables. Well, this is possible if your prod db is less
> than 300GB
>
> Thanks..

ISUG Enhancement request 3347 has been created. Members can vote at
http://my.isug.com/index.php?mo=is&op=vi&iid=3347&type=1


Cory Sane Posted on 2008-02-21 04:38:47.0Z
Reply-To: "Cory Sane" <cory!=sane>
From: "Cory Sane" <cory!=sane>
Newsgroups: sybase.public.ase.product_futures_discussion
References: <c0cf3381-b2f4-4334-a6ee-c0e34fee6517@p69g2000hsa.googlegroups.com>
Subject: Re: CREATE DATABASE ...
Lines: 42
Organization: [TeamSybase Intern}
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47bd0057$1@forums-1-dub>
Date: 20 Feb 2008 20:38:47 -0800
X-Trace: forums-1-dub 1203568727 10.22.241.152 (20 Feb 2008 20:38:47 -0800)
X-Original-Trace: 20 Feb 2008 20:38:47 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1962
Article PK: 97574

Renzo,

I've had the same problems... This is one of those cases where you have to
keep the build sql code stored safely way... I know that it is not always
possible when dealing with vendor applications.

Part of the trick would be to extract elements of the stored procs that we
cannot see. I also believe that this would be a good feature for users.


--
Cory Sane
[TeamSybase Intern]
Certified Sybase Associate DBA for ASE 15.0
not a Sybase Inc. employee

<Renzo.aquino@gmail.com> wrote in message
news:c0cf3381-b2f4-4334-a6ee-c0e34fee6517@p69g2000hsa.googlegroups.com...
> As a DBA I have a horrible experience of creating a test db from a
> production copy. Out of 5000+ stored procedures there were 200 of
> these with #temp table dependencies either this was created from the
> applications or from the parent stored procedures. Rebuilding this
> #temp table was painstaking because the developer did not leave any
> trace how these tables was created. I have to look at each
> applications source codes and some of them are already a legacy with
> only the exe available.
>
> I wish Sybase will have a new feature in creating a test
> database copy from another db source were the only missing part is the
> data.
>
> Like:
>
> create database testdb on dev1=### log on log1=## using proddb except
> data
>
> Somebody might say... well why not load a backup copy and then
> truncate the tables. Well, this is possible if your prod db is less
> than 300GB
>
> Thanks..