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.

Using ASE with an existing database - How to import

11 posts in General Discussion Last posting was on 2012-08-01 07:17:41.0Z
ccassano Posted on 2012-07-31 15:27:15.0Z
Sender: f63.5017f7a0.1804289383@sybase.com
From: ccassano@emprisecorporation.com
Newsgroups: sybase.public.ase.general
Subject: Using ASE with an existing database - How to import
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <5017f952.fb1.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 31 Jul 2012 08:27:15 -0700
X-Trace: forums-1-dub 1343748435 172.20.134.41 (31 Jul 2012 08:27:15 -0700)
X-Original-Trace: 31 Jul 2012 08:27:15 -0700, 172.20.134.41
Lines: 20
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31288
Article PK: 74180

Hi, another company sent us an ASE database but we've never
used ASE so it's new to us. I installed ASE 15.7 developer
edition on my machine but I'm not sure how to proceed now.

The existing database came in a zip file, and when I unzip
it I see a few folders: backups, data, config, extracts,
logs, and scripts.

Now, I can see that the stuff in the data folder is similar
to the stuff in MY ASE data folder at D:\Sybase\data, so I
tried copying the data folder from the existing database to
D:\Sybase\data but now my server gets errors when I try to
connect to it (no surprise, so I put the old data folder
back and now I can connect again without errors.

Obviously just copying the data folder doesn't work, so how
do I properly import this database into ASE? I'm on
Windows.

Thank you.


Rob V Posted on 2012-07-31 15:43:51.0Z
From: Rob V <rob@sypron.nl>
Reply-To: rob@sypron.nl
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:14.0) Gecko/20120713 Thunderbird/14.0
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Using ASE with an existing database - How to import
References: <5017f952.fb1.1681692777@sybase.com>
In-Reply-To: <5017f952.fb1.1681692777@sybase.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: <5017fd37$1@forums-1-dub>
Date: 31 Jul 2012 08:43:51 -0700
X-Trace: forums-1-dub 1343749431 172.20.134.152 (31 Jul 2012 08:43:51 -0700)
X-Original-Trace: 31 Jul 2012 08:43:51 -0700, vip152.sybase.com
Lines: 44
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31289
Article PK: 74181


On 31-Jul-2012 17:27, ccassano@emprisecorporation.com wrote:
> Hi, another company sent us an ASE database but we've never
> used ASE so it's new to us. I installed ASE 15.7 developer
> edition on my machine but I'm not sure how to proceed now.
>
> The existing database came in a zip file, and when I unzip
> it I see a few folders: backups, data, config, extracts,
> logs, and scripts.
>
> Now, I can see that the stuff in the data folder is similar
> to the stuff in MY ASE data folder at D:\Sybase\data, so I
> tried copying the data folder from the existing database to
> D:\Sybase\data but now my server gets errors when I try to
> connect to it (no surprise, so I put the old data folder
> back and now I can connect again without errors.
>
> Obviously just copying the data folder doesn't work, so how
> do I properly import this database into ASE? I'm on
> Windows.
>
> Thank you.
>

You need to start to find the master device. Do you have a file named
'master' or soemthing?

--
HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Professional DBA for Sybase ASE, IQ, Replication Server

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase IQ Quick Reference Guide"
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------


Mark A. Parsons Posted on 2012-07-31 16:10:54.0Z
Sender: 107b.5017febe.1804289383@sybase.com
From: Mark A. Parsons
Newsgroups: sybase.public.ase.general
Subject: Re: Using ASE with an existing database - How to import
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <5018038e.114b.1681692777@sybase.com>
References: <5017f952.fb1.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 31 Jul 2012 09:10:54 -0700
X-Trace: forums-1-dub 1343751054 172.20.134.41 (31 Jul 2012 09:10:54 -0700)
X-Original-Trace: 31 Jul 2012 09:10:54 -0700, 172.20.134.41
Lines: 56
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31292
Article PK: 74182

While it may be possible to access the database by re-using
the database devices ... this can get a bit complicated as
you'll need to mess around with the path where the devices
are stored and/or manually updating the master database
(assuming you can get the dataserver to startup on the
master device).

Is the source from an ASE 15.7 instance? 15.5 instance?
some other ASE version? not sure?

Personally, I'd probably want to start with what's in the
backups directory.

Do you know the name of the database that you're looking to
access? If so, are there any files (in the backups
directory) with a name that includes the database name?

If you have a copy of a database dump file (eg, in the
backups directory) then you should be able to use your ASE
instance to read the header of the dump file ... from the
header you can get a lot of good info, eg, ASE version of
the source database, database size and structure (this makes
it mucho easier to create a database you can load the dump
file into), etc.

Depending on what you need to pull from the database it may
also be possible to just mount the dump file as an archive
database.

There are a few different ways you may be able to access the
database ... but regardless of the route you take you're
going to need some some basic- to mid-level Sybase DBA
skills (or a lot of pointers).

> Hi, another company sent us an ASE database but we've
> never used ASE so it's new to us. I installed ASE 15.7
> developer edition on my machine but I'm not sure how to
> proceed now.
>
> The existing database came in a zip file, and when I unzip
> it I see a few folders: backups, data, config, extracts,
> logs, and scripts.
>
> Now, I can see that the stuff in the data folder is
> similar to the stuff in MY ASE data folder at
> D:\Sybase\data, so I tried copying the data folder from
> the existing database to D:\Sybase\data but now my server
> gets errors when I try to connect to it (no surprise, so I
> put the old data folder back and now I can connect again
> without errors.
>
> Obviously just copying the data folder doesn't work, so
> how do I properly import this database into ASE? I'm on
> Windows.
>
> Thank you.


ccassano Posted on 2012-07-31 19:19:52.0Z
Sender: f63.5017f7a0.1804289383@sybase.com
From: ccassano@emprisecorporation.com
Newsgroups: sybase.public.ase.general
Subject: Re: Using ASE with an existing database - How to import
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50182fd8.174a.1681692777@sybase.com>
References: <5018038e.114b.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 31 Jul 2012 12:19:52 -0700
X-Trace: forums-1-dub 1343762392 172.20.134.41 (31 Jul 2012 12:19:52 -0700)
X-Original-Trace: 31 Jul 2012 12:19:52 -0700, 172.20.134.41
Lines: 68
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31295
Article PK: 74184

We know that it's from ASE version 12.5 and we would use the
backup in the backup folder but the modified date is in 2010
so we think it's a very old backup.

Also I tried to find ASE 12.5 to install but I could only
find version 15.7. I made sure to set the page size to 2k
because it said that versions before 15 used page size 2k so
I was under the impression that we should be able to use the
12.5 database with ASE 15.7.

Thank you

> While it may be possible to access the database by
> re-using the database devices ... this can get a bit
> complicated as you'll need to mess around with the path
> where the devices are stored and/or manually updating the
> master database (assuming you can get the dataserver to
> startup on the master device).
>
> Is the source from an ASE 15.7 instance? 15.5 instance?
> some other ASE version? not sure?
>
> Personally, I'd probably want to start with what's in the
> backups directory.
>
> Do you know the name of the database that you're looking
> to access? If so, are there any files (in the backups
> directory) with a name that includes the database name?
>
> If you have a copy of a database dump file (eg, in the
> backups directory) then you should be able to use your ASE
> instance to read the header of the dump file ... from the
> header you can get a lot of good info, eg, ASE version of
> the source database, database size and structure (this
> makes it mucho easier to create a database you can load
> the dump file into), etc.
>
> Depending on what you need to pull from the database it
> may also be possible to just mount the dump file as an
> archive database.
>
> There are a few different ways you may be able to access
> the database ... but regardless of the route you take
> you're going to need some some basic- to mid-level Sybase
> DBA skills (or a lot of pointers).
>
> > Hi, another company sent us an ASE database but we've
> > never used ASE so it's new to us. I installed ASE 15.7
> > developer edition on my machine but I'm not sure how to
> > proceed now.
> >
> > The existing database came in a zip file, and when I
> > unzip it I see a few folders: backups, data, config,
> > extracts, logs, and scripts.
> >
> > Now, I can see that the stuff in the data folder is
> > similar to the stuff in MY ASE data folder at
> > D:\Sybase\data, so I tried copying the data folder from
> > the existing database to D:\Sybase\data but now my
> > server gets errors when I try to connect to it (no
> > surprise, so I put the old data folder back and now I
> > can connect again without errors.
> >
> > Obviously just copying the data folder doesn't work, so
> > how do I properly import this database into ASE? I'm on
> > Windows.
> >
> > Thank you.