Hello,

Please give me the exact instructions to bring a V11 database back to V9.

ie: how to properly Unload and Reload it

We need to get rid of Sybase V11 as soon as possible.

Please someone help with instructions.

-Robert

Hello,

Please -- I tried using UNLOAD and RELOAD commands and in Version 9, it's
complaining that "QUOTE" is not valid when trying to load the data.

Where is this documentation to bring this thing back to V9?

-Robert

"Robert Paresi" <FirstInitialLastName (AT) innquest (DOT) com> wrote

I haven't tested this...

Assuming you haven't changed the schema in V11, and you still have
some copy of the V9 database...

Run a Version 11 dbunload of both schema and data. You will be using
the data files, but only some parts of the reload.sql file.

Run a dbunload of the V9 database. You will be modifying the
reload.sql file but disposing of the data files.

Modify the V9 reload.sql file to use the LOAD TABLE statements from
the V11 reload.sql. The only differences should be the file names;
different numbered file names. If the LOAD TABLE statements use
different options there may be problems to discuss.

Run the modified V9 reload.sql file through V9 dbisql.

Breck





On 23 Oct 2009 07:24:30 -0700, "Robert Paresi"
<FirstInitialLastName (AT) innquest (DOT) com> wrote:

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter (AT) risingroad (DOT) com

Hi,

It doesn't like this:

FORMAT TEXT

Meaning, when it loads the data, it doesn't like that.

I tried it with unload statements, and it didn't like QUOTE

I tried it with SQL statements, and it doesn't like "FORMAT TEXT"

-Robert

V9 uses FORMAT ASCII instead of FORMAT TEXT.

I would recommend tech support, too, if you have the time and nerves...

Regards
Volker

Robert Paresi wrote:

V11 schema (CREATE TABLE etc) is unlikely to work in V9. See my other
message; it talks about combining the V9 dbunload schema with the V11
dbunload data files.

This is something that requires careful checking... it is fraught with
error. Most folks fallback plans involve parallel operations rather
than "data downgrade" steps. AFAIK there is no detailed or supported
documentation about downgrading data, in this or any other database
product.

So... it might be possible, but certainly NOT if panic reigns.

Breck


On 23 Oct 2009 08:36:35 -0700, "Robert Paresi"
<FirstInitialLastName (AT) innquest (DOT) com> wrote:

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter (AT) risingroad (DOT) com

Hi,

I really don't want to be placed on hold or sit there and explain my issues.
My nerves are already shot.

Now its more issues. I am creating the V9 database and when it does it,
SCJVIEW GPF's on my WIN2008 server.

I do utilities / create database, put in all the parms, press Finish. It
creates the .db files and then it says "initializing ultralite" something or
other, and then just GPF's on my box. So, I can't even create a blank
database.

I don't feel like discussing this with someone from Sybase Support Center.
They aren't programmers.

-Robert


"Volker Barth" <No_VBarth (AT) Spam_GLOBAL-FINANZ (DOT) de> wrote

Breck,

I don't know what your position is with Sybase or if your information is an
'official' source.

I have two entire systems (production and internal) we went to V11 with.
Now, we are in a panic because we have two big issues - internal customers
having issues and external customers having issues.

You may be here to 'help' - but right now, we are in a predictement where
this whole thing is completely frustrating. I'm highly doubting it's
fragmentation issues because it's two database, two entirely different
systems all behaving in the same manner. It may be changes in the way the
database handles things because of our application development tool.
Getting support for that tool is worse and close to being unsupported - and
you really don't know where they stand on anything.

It's far easier to put everything back to the way it was and just leave it
alone. My problem is that V9 GPF's when using WIN7 so now I'm in a catch -
22.

We give Sybase close to 100K a year in sales --- I'm not going to be placed
in some support tree and go through some help line tree.

I curse the day I went to V11. But, the issues are probably a combination
of our compiler application and something new that Sybase V11 is doing, and
the way it is fetching records.

For example ... the compiler (RAD TOOL) does a select x from y order by
keyfield desc - to find the next primary key. It was extremely fast in V9,
but it seems like it is 1 to 5 seconds on V11. I know that "select first"
is sub-second, but we do not control what the driver does in the
application - again, it is a RAD tool. I have no clue why SQA 11 would
handle this different than SQA 9 but it does ... with a huge lag. There
are other screens which have slowed to a crawl.

There has got to be a way to migrate a DB back to V9.

I'm trying it now - but now my SCJVIEW is GPF'ing adn not even allowing me
to create an empty database.

Why can't I just create an empty database.
Run the unload statements over it and it puts it all back.

I tried it and my tables are fine, my security is fine, everything is fine -
the ONLY problem is the FORMAT TEXT statement is wrong.

I went through the file with ULEDIT and pulled that all out. Then I went to
recreate the file and SCJVIEW GPF's and won't create an empty database.

It's yet another issue now I'm dealing with - and I shouldn't for the price
of Sybase SQL Anywhere.

-Robert

Robert,

I can't comment on Sybase tech support other than saying that my few
cases were solved to my content.

But if your SC fails, then something seems broken.

What about using the command line tools like DBINIT or DBISQLC? AFAIK
the reload.log will contain a comment with the DBINIT or CREATE DATABASE
statement ready for use (though in the SA 11 syntax).


Regards
Volker


Robert Paresi wrote:

Hi,

I rebooted the server and now it works. LOL!

Ok, so I modified the UNLOAD statement and removed the FORMAT TEXT.

I then ran it and hit continue on about 10 messages.

Everything converted (permissions, data, comments, etc.) except for the
Triggers. They bombed, but I can just reenter them.

Now, I started up the DB and it seems like it fine. Fingers Crossed.

Now I will go back after lunch and see if the speed it back to normal.

If it is, then I will stay with V9 for now.

-Robert