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.

Need help with an export

4 posts in General Discussion Last posting was on 2008-11-05 09:48:10.0Z
dbastien Posted on 2008-11-04 18:51:52.0Z
Sender: 19c6.491097ab.1804289383@sybase.com
From: dbastien@risd.edu
Newsgroups: ianywhere.public.general
Subject: Need help with an export
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <491099c8.1ad7.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 4 Nov 2008 10:51:52 -0800
X-Trace: forums-1-dub 1225824712 10.22.241.41 (4 Nov 2008 10:51:52 -0800)
X-Original-Trace: 4 Nov 2008 10:51:52 -0800, 10.22.241.41
Lines: 23
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7125
Article PK: 5343

Hello

I am writing to this newsgroup at the suggestion of folks
from Sybase. I have a database that uses Sybase Adapative
Server Anywhere 8.1 as the ODBC. I am trying to replace my
current database with another database and the potenial new
software developer has asked me to "if it would be possible
for you to perform an "unload" process in Sybase (Sybase
Central). This would give us files with the tablestructure
plus *.csv files with all tables and their content. These
files would allow us to see the data and the structure and
do the migration estimation."

The term "unload", seems to suggest that I would be
completely unloading my data and looking through whatever
documentation I could find, suggests just that. I don't want
to "unload" my database I want to copy the data and its
structure. How would I do that? I am sure you might have
guessed but I have no technial experience with the backend
of these applications. Can someone detail how best to copy
my database (which was written on Powerbulider) and keep the
table structure in tact.
Thank you for you help. Denise B.


Arthur Hefti Posted on 2008-11-05 09:48:10.0Z
From: "Arthur Hefti" <arthur@catsoft.ch>
Newsgroups: ianywhere.public.general
References: <491099c8.1ad7.1681692777@sybase.com>
Subject: Re: Need help with an export
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49116bda@forums-1-dub>
Date: 5 Nov 2008 01:48:10 -0800
X-Trace: forums-1-dub 1225878490 10.22.241.152 (5 Nov 2008 01:48:10 -0800)
X-Original-Trace: 5 Nov 2008 01:48:10 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7128
Article PK: 5344

Denise

unload leaves the data in your database. I creates your database definition
in SQL in a folder. In addition it also places all the data there.

Arthur

<dbastien@risd.edu> wrote in message
news:491099c8.1ad7.1681692777@sybase.com...
> Hello
>
> I am writing to this newsgroup at the suggestion of folks
> from Sybase. I have a database that uses Sybase Adapative
> Server Anywhere 8.1 as the ODBC. I am trying to replace my
> current database with another database and the potenial new
> software developer has asked me to "if it would be possible
> for you to perform an "unload" process in Sybase (Sybase
> Central). This would give us files with the tablestructure
> plus *.csv files with all tables and their content. These
> files would allow us to see the data and the structure and
> do the migration estimation."
>
> The term "unload", seems to suggest that I would be
> completely unloading my data and looking through whatever
> documentation I could find, suggests just that. I don't want
> to "unload" my database I want to copy the data and its
> structure. How would I do that? I am sure you might have
> guessed but I have no technial experience with the backend
> of these applications. Can someone detail how best to copy
> my database (which was written on Powerbulider) and keep the
> table structure in tact.
> Thank you for you help. Denise B.


Chris Keating (Sybase iAnywhere) Posted on 2008-11-04 19:09:39.0Z
From: "Chris Keating (Sybase iAnywhere)" <keating_spam_free@ianywhere.com>
User-Agent: Thunderbird 2.0.0.17 (Windows/20080914)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Need help with an export
References: <491099c8.1ad7.1681692777@sybase.com>
In-Reply-To: <491099c8.1ad7.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: <49109df3@forums-1-dub>
Date: 4 Nov 2008 11:09:39 -0800
X-Trace: forums-1-dub 1225825779 10.22.241.152 (4 Nov 2008 11:09:39 -0800)
X-Original-Trace: 4 Nov 2008 11:09:39 -0800, vip152.sybase.com
Lines: 49
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7126
Article PK: 5345

UNLOADing does allow you to get the schema and data. It does come in a
form that is for SQL Anywhere but can be edited for the use that you
propose.

The other option is to use the PowerBuilder pipeline object to 'migrate'
the databases.


--

Chris Keating

****************************************
Please only post to the newsgroup

SQL Anywhere Developer Community
http://www.sybase.com/developer/library/sql-anywhere-techcorner
SQL Anywhere Blog Center
http://www.sybase.com/sqlanyblogs
Maintenance releases and EBFs
http://downloads.sybase.com/swx/sdmain.stm
Use Case Express to report bugs
http://case-express.sybase.com

dbastien@risd.edu wrote:
> Hello
>
> I am writing to this newsgroup at the suggestion of folks
> from Sybase. I have a database that uses Sybase Adapative
> Server Anywhere 8.1 as the ODBC. I am trying to replace my
> current database with another database and the potenial new
> software developer has asked me to "if it would be possible
> for you to perform an "unload" process in Sybase (Sybase
> Central). This would give us files with the tablestructure
> plus *.csv files with all tables and their content. These
> files would allow us to see the data and the structure and
> do the migration estimation."
>
> The term "unload", seems to suggest that I would be
> completely unloading my data and looking through whatever
> documentation I could find, suggests just that. I don't want
> to "unload" my database I want to copy the data and its
> structure. How would I do that? I am sure you might have
> guessed but I have no technial experience with the backend
> of these applications. Can someone detail how best to copy
> my database (which was written on Powerbulider) and keep the
> table structure in tact.
> Thank you for you help. Denise B.


"Frank Ploessel" <fpl... Posted on 2008-11-05 09:27:29.0Z
Subject: Re: Need help with an export
From: "Frank Ploessel" <fpl...@d_e.i_m_s_h_e_a_l_t_h.c_o_m>
Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
References: <491099c8.1ad7.1681692777@sybase.com>
Content-Transfer-Encoding: 7bit
Message-ID: <op.uj4272xaj0bybf@bonw01164.internal.imsglobal.com>
User-Agent: Opera Mail/9.51 (Win32)
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 5 Nov 2008 01:27:29 -0800
X-Trace: forums-1-dub 1225877249 10.22.241.152 (5 Nov 2008 01:27:29 -0800)
X-Original-Trace: 5 Nov 2008 01:27:29 -0800, vip152.sybase.com
Lines: 38
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7127
Article PK: 5346

Denise,

Why do you not just run the UNLOAD and look at the unloaded files and then
decide if this is what you need?
unload will produce a set of files (one for each table in the database)
containing the data, and a file (by default named reload.sql) containing
the structure definition (in the form of create table statements) and the
instructions to load the data from the data files into newly created
tables.

Frank

Am 04.11.2008, 19:51 Uhr, schrieb <dbastien@risd.edu>:

> Hello
>
> I am writing to this newsgroup at the suggestion of folks
> from Sybase. I have a database that uses Sybase Adapative
> Server Anywhere 8.1 as the ODBC. I am trying to replace my
> current database with another database and the potenial new
> software developer has asked me to "if it would be possible
> for you to perform an "unload" process in Sybase (Sybase
> Central). This would give us files with the tablestructure
> plus *.csv files with all tables and their content. These
> files would allow us to see the data and the structure and
> do the migration estimation."
>
> The term "unload", seems to suggest that I would be
> completely unloading my data and looking through whatever
> documentation I could find, suggests just that. I don't want
> to "unload" my database I want to copy the data and its
> structure. How would I do that? I am sure you might have
> guessed but I have no technial experience with the backend
> of these applications. Can someone detail how best to copy
> my database (which was written on Powerbulider) and keep the
> table structure in tact.
> Thank you for you help. Denise B.