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.

Starting Database

3 posts in General Discussion Last posting was on 2007-06-20 08:43:43.0Z
Doug Sheehan Posted on 2007-06-19 17:13:45.0Z
Sender: 71e3.46780e3b.1804289383@sybase.com
From: Doug Sheehan
Newsgroups: ianywhere.public.general
Subject: Starting Database
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <46780ec9.71f5.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 19 Jun 2007 10:13:45 -0700
X-Trace: forums-1-dub 1182273225 10.22.241.41 (19 Jun 2007 10:13:45 -0700)
X-Original-Trace: 19 Jun 2007 10:13:45 -0700, 10.22.241.41
Lines: 4
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6079
Article PK: 2541

I downloaded Sybase version 10 Developer. I can't seem to
start the database. I want to convert a Sybase version 9
database to version 10 and play with it. I can't log in.
Where do I find some kind of "how to get started" document?


Joshua Savill Posted on 2007-06-19 17:16:42.0Z
From: "Joshua Savill" <nospam_jsavill@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <46780ec9.71f5.1681692777@sybase.com>
Subject: Re: Starting Database
Lines: 18
Organization: iAnywhere Solutions
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.3138
NNTP-Posting-Host: jsavill-d620.sybase.com
X-Original-NNTP-Posting-Host: jsavill-d620.sybase.com
Message-ID: <46780f7a$1@forums-1-dub>
Date: 19 Jun 2007 10:16:42 -0700
X-Trace: forums-1-dub 1182273402 10.25.98.186 (19 Jun 2007 10:16:42 -0700)
X-Original-Trace: 19 Jun 2007 10:16:42 -0700, jsavill-d620.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6080
Article PK: 2537

I'd start in the documentation under the following section:

SQL Anywhere® 10 - Changes and Upgrading

Upgrading to SQL Anywhere 10

--
Joshua Savill
iAnywhere Solutions - Product Support Analyst

<Doug Sheehan> wrote in message news:46780ec9.71f5.1681692777@sybase.com...
>I downloaded Sybase version 10 Developer. I can't seem to
> start the database. I want to convert a Sybase version 9
> database to version 10 and play with it. I can't log in.
> Where do I find some kind of "how to get started" document?


Breck Carter [Team iAnywhere] Posted on 2007-06-20 08:43:43.0Z
From: "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Starting Database
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <85qh73dc4c24idvkru8surh3kf7j3rk7q0@4ax.com>
References: <46780ec9.71f5.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 208.253.124.99
X-Original-NNTP-Posting-Host: 208.253.124.99
Date: 20 Jun 2007 01:43:43 -0700
X-Trace: forums-1-dub 1182329023 208.253.124.99 (20 Jun 2007 01:43:43 -0700)
X-Original-Trace: 20 Jun 2007 01:43:43 -0700, 208.253.124.99
Lines: 53
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6081
Article PK: 2538

If you're a command-line kinda guy, here is my template Windows batch
file run_dbunload_upgrade_to_10.bat. It does the
unload-reload-all-in-one-dbunload-step, then starts dbeng10 and dbisql
so you can make sure the new database is up and running.

Be sure to stop *all* database engines on the computer you're using,
before starting the upgrade.

Watch out for wrapped lines in the newsgroup display...

=====
REM dbunload...
REM -an ... where to put new database
REM -c ... old database startup connection string
REM -o ... where to put unload console display text file
REM -v verbose mode for console display

PAUSE MAKE SURE YOU DO NOT HAVE ANY ENGINES RUNNING.

"%SQLANY10%\win32\dbunload.exe" -an ddd10.db -c
"DBF=ddd.db;UID=dba;PWD=sql" -o dbunload_log_ddd.txt -v
PAUSE dbunload/reload done...

REM dbeng10...
REM -c ... initial RAM cache size
REM -o ... where to put server console display text file
REM -os ... when to rename and restart server console display text
file
REM -x none speed startup by disabling client protocols except shmem
REM ddd10.db new database to start

"%SQLANY10%\win32\dbspawn.exe" -f "%SQLANY10%\win32\dbeng10.exe" -c
100M -o dbeng10_log_ddd10.txt -os 10M -x none ddd10.db
PAUSE dbeng10 started...

REM dbisql...
REM -c ... new database connection string

"%SQLANY10%\win32\dbisql.exe" -c "ENG=ddd10;DBN=ddd10;UID=dba;PWD=sql"
PAUSE dbisql running...On 19 Jun 2007 10:13:45 -0700, Doug Sheehan

wrote:

>I downloaded Sybase version 10 Developer. I can't seem to
>start the database. I want to convert a Sybase version 9
>database to version 10 and play with it. I can't log in.
>Where do I find some kind of "how to get started" document?

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
breck.carter@risingroad.com