Change of a SQLAnywhere-DB-Structure(old) to DB-Structure(new)
I have an application which runs at a customer with a SQLAnywhere-Database.
Now my development went on; I have added new Tabels, added new Columns to
but I never delete any cloumns or tables.
I am look for a tool or a peace of PB-Code which upgrades the structure of
the old database
to the new structure. Something which generates the "Alter Table/Add Table
Upgarde-Script " out of the
difference DB(new) - DB(old).
Who can help me ?
phone 0049 8191 32 08 61
fax 0049 8191 32 08 90
The...Unload for upgrading ASA9 DB to ASA 11 DB not working
This is a multi-part message in MIME format.
Content-Type: text/plain; charset="ISO-8859-1"
I have a client that uses ASA. He now wants to migrate from
ASA 9 to ASA 11 and from Windows XP to Windows 7. For that
reason he has to unload/reload the ASA 9 database. In Sybase
Central "Unload and reload into a new database" is choosen.
While the unload works with the free developers edition, it
does not work with the licensed workgroup edition (SQL
Anywhere Network Server Version 18.104.22.1684, Workgroup
editi...Change of a SQLAnywhere DB-Structure(old) to DB-Structure(new)
I want to change the old structure of a SQLAnywhere-DB to a new structure;
I know, that i can do this in PB-Script with Embedded-SQL
"Alter-Table-Statements"; but ....
I don't know them
I'm looking for a Tool/ PC-Code generates me these "Alter-Table-Statements"
out of the difference
of the two Databases (old -> new).
No columns or Tabels will be deleted in the new Database; only columns and
Tables will be added.
phone 0049 8191 32 08 61
fax 0049 8191 32 08 90
...What generals generally do
Reading a McChrystal thread elsewhere, I came across someone quoting a
> I spent 33 years and four months in active military service and
> during that period I spent most of my time as a high class thug for
> Big Business, for Wall Street and the bankers. In short, I was a
> racketeer, a gangster for capitalism. I helped make Mexico and
> especially Tampico safe for American oil interests in 1914. I helped
> make Haiti and Cuba a decent place for the National City Bank boys to
> collect revenues in. I ...Error Unloading DB
Trying to convert the 6.0 database to work on a new 8.0 server...get a
message to instructing to unload and then reload....During unload process,
get the message: "SQL error: Cannot access file 'rt.jar' --No such file
or directory. Could not unload the database 'DBNAME'.
Copied rt.jar from old 6.0 server to new server....now unload fails and
says "JDK Version in 1.3.1. does not match 1.1.8. How can I fix this?
You need to unload without Java in Database support if you are not using
Java in the Database. Or obtain the separately licensable Ja...Unload .db into Tables
I have a product called Sharkware that I believe uses SQL Anywhere database
engine. Pardon my lack of technical wording, we are a small sales office
using Sharkware as a contact manager. Anyways, we would like to export all
of the data into tables from a shark.db file that we have been building on
for 12 years. I have tried doing it in Excell and have not had any sucess.
I have tried using the SQL Central in the Sybase SQL Anywhere 5.0
directory, and I get to the point where it starts to unload, but cannoit
start the database engine. I am doing this from a workstation as opp...DB Tools
I am trying to programmatically unload and recreate a database suing the
DB Tolls API. I cannot seem to figure out which parameters (or what they
should be set to) to specify in the an_unload_db structure in order to
successfully unload/reload the data. Any help would be great!
I wrote a similar utility. I set the following fields.
memset( &unload_info, 0, sizeof( an_unload_db ) );
unload_info.version = DB_TOOLS_VERSION_NUMBER;
unload_info.no_confirm = 1;
unload_info.errorrtn = (MSG_CALLBACK)ErrorCallBack;
...Unload / Reload DB
Just wanted to say that there exist a utility for
help you unload / reload your SQLAnywhere database.
Also - you can change collating sequence for your db by using this
Price ..: FREE !
Check it out ! - http://www.powerutilities.no/ (Under the section
Knut Erik Hollund
...Unload load DB
I am changing from SQLAnywhere 8.0.2 to 9.0!
Now i have the problem that my special german
characters will not displayed correctly in 9.0!
What do i wrong?
My Steps till now where:
1) I tried to open the 8.0.2 DB from Central.
2) Central asked me to unload the db load the database
into 9.0 DB .
After that I special characters where not correct displayed!
Christian Ternek wrote:
> I am changing from SQLAnywhere 8.0.2 to 9.0!
> Now i have the problem that my special german
> characters will not displayed correctly in 9.0!
...General db queries
I am currently running the IbuySpy Portal on my lap top using MSDE. Could anyone clarify a few points for me ...
1) If I buy SQL Server 2000 which I aim to do ... will this simply install over my MSDE and leave my portal database intact and run it as per normal?
2) I currently use web matrix to explore my portal database - I notice that in the users table of the portal the field size property for the key UserID field is set to "4" - does this in fact mean that there is only capacity to have 9999 users and then no more can be added? I assume this is correct.
3) A...Unload db failed
I've done this before successfully, but I'm getting an error and failing
when attempting to uload my db into a new one:
I'm unloading into a new database, unloading structure and data, exclude
java refs. The error message:
Writing QAnywhere message data
Writing option settings
***** SQL error: Cannot access file 'custom.sql' -- No such file or
The database 'mobilevet' could not be unloaded.
I get this same error using sy central or the command line:
>dbunload -c "uid=DBA;pwd=sql;dbf=c:\temp\orig.db" -an c:\temp\new...Sqlanywhere.general missing?
I have not been able to get to the sqlanywhere.general news group in a
couple of weeks now. Has something changed?
The newsgroups have moved to a new server. You will need to reset your
Joshua Savill , SYBASE
iAnywhere Solutions - Technical Support
"James L. Blackburn" <firstname.lastname@example.org> wrote in message
> I have not been able to get to the sqlanywhere.general news group in a
> couple of weeks now. Has something changed?
Same name, different IP address. It co...How to Script a SQLAnyWhere DB
I have created a database using sqlanywhere 5.5 pro and I would now like to
generate a script of the database so that I can run this script on any new
client's computer that purchases my program. I know that I can just create
a backup copy of the blank DB, but having the script would be nice as well.
This same apps works with SQL Server too and I can use the Enterprise
Manager in SQL Server to script the entire database.
How can I do this in SQLA?
See the documentaion under 'dbunload'
...membership DB, profile DB, and role DB
I use the following code to programatically cycle through each record in an mdb database and create users with the Membership.CreateUser method. The code also creates a profile for the same user before moving to the next record. The membership and profile DB is on an SQL 2000 server.
How can I assign all these users to the role of user in this section of code?
Also any idea why only 104 out of 148 records are added to the Membership table while all 148 profiles are created? A sample record would be:UserName DIST ...