MySQL Forums - Sybase

Sybase and PowerApps (1 reply)

tejaswini kancharla — Wed, 15 Jun 2022 17:52:11 +0000

I currently am trying to build a PowerApps that needs to connect to Sybase database. I do not see any connector for Sybase in PowerApps.

I'd like to ask for options on how I can connect to Sybase? I saw one option which is CData Connect Cloud which comes at a price. Aside from this, any suggestions would be greatly appreciated.

Thanks!

Error while logging to Mysql (1 reply)

Daniel Zampieri — Fri, 27 Dec 2019 16:17:00 +0000

I get the following error while I log to Mysql from my virtual server:
Database error: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
What can i do? Thanks

ASE 15.5 to SQL server 2016 migration concepts (2 replies)

senthil vinayagam — Wed, 01 Feb 2017 04:51:01 +0000

Hello ,

Myself oracle dba, worked on Sybase 10 years before. Now Got requirement to migrate Sybase ASE 15.5 to SQL server 2016. Kindly help me for the technical aspect of costing

1) what is the best way to migrate ASE 15.5 to SQL server 2016
Give me some url to help so that I can go through
2) what will be costing involved for each options that you suggest ( ASE 15.5 to SQL server 2016)

Please provide some url for my understanding . Thanks a lot ... waiting for your reply
S

MySQL Workbench: migration from Sybase (no replies)

Edwin Desouza — Wed, 25 May 2016 18:42:03 +0000

Bug #81562 Workbench Migrate from Sybase to MySQL does not copy primary keys
http://bugs.mysql.com/bug.php?id=81562

Bug #81554 Data Migration Wizard: using [] quoted objects with Sybase fails on max 28 bytes
http://bugs.mysql.com/bug.php?id=81554

Bug #81545 Data Migration: Changed sybase `getTriggerNames` to singlequoted search on ‘TR'
http://bugs.mysql.com/bug.php?id=81545 [patch]

Bug #81546 Workbench Migration weird error when trying to connect using an ODBC FreeTDS
http://bugs.mysql.com/bug.php?id=81546

Bug #81568 Workbench Preferences Pane Layout not wrapped
http://bugs.mysql.com/bug.php?id=81568

Adaptative Server Anywhere to My SQL (1 reply)

Gabriel Vilella — Wed, 09 Dec 2015 11:28:11 +0000

Hello,

I need to migrate a data base which is in my local computer to a remote server. The local DB runs in Adaptative Server Anywhere 9.0.2.2451 RDBMS while the remote server uses Maria DB 10.0.20 (which is completely compatible with MySQL).

After some research I've found out I could use a ODBC driver to enable the migration. So I am using Sybase SQL Anywhere 9.0 drive and Workbench 6.0. But since I am a complete beginner on IT I am struggling to fill the migration wizard form of the workbench. So I ask:

1-On the Source Selection tab:
a)There is a Driver field which I should put the ODBC Drive'name. Where do I get the right name of the driver?
b)There is a hostname and port fields, I believe since the DB is on my local computer I can leave it blank, right?
c)There is an additional arguments to be used in ODBS String, should I pass any?

Sybase Migration (3 replies)

Chris Keene — Mon, 02 Mar 2015 10:01:43 +0000

I work in a University Library and we are moving to a new library system. The move does not include historical data and I'm hoping to migrate our current Sybase db to MySql database so we can refer to it for future use. (essential for some financial information)

I'm having problems with the Mysql Workbench Migration from Sybase.
I'm using Workbench 6.2 on Windows 7. ODBC to connect to Sybase ASE 15. Mysql 5.5.1

All seems well through the wizard. Connections seem ok. the database structure is created successfully in MySQL. The problem comes at the actual migration of data, nearly all tables fail (but not all).

The tables fail due to a type mismatch.
eg from the logs
ERROR: `prod_talis`.`ITEM_DESCRIPTION_TYPE`:Type mismatch fetching field 2 (should be char, was MYSQL_TYPE_STRING)
ERROR: `prod_talis`.`ITEM_DESCRIPTION_TYPE`:Failed copying 666 rows
`prod_talis`.`ITEM_QUERY`:Copying 19 columns of 27728 rows from table [prod_talis].[dbo].[ITEM_QUERY]
ERROR: `prod_talis`.`ITEM_QUERY`:Type mismatch fetching field 1 (should be long, was MYSQL_TYPE_STRING)
`prod_talis`.`ITEM_CHECK_IN`:Copying 17 columns of 147524 rows from table [prod_talis].[dbo].[ITEM_CHECK_IN]
ERROR: `prod_talis`.`ITEM_CHECK_IN`:Type mismatch fetching field 1 (should be long, was MYSQL_TYPE_STRING)
ERROR: `prod_talis`.`ITEM_QUERY`:Failed copying 27728 rows

Looking at one field as an example: ITEM_DESCRIPTION_TYPE.SUB_TYPE (field 2 in that table)

The actual Sybase type is tinyint.

At the Source Migration stage we get the following warning
WARNING: Sybase reverseEngineerTableColumns: Column datatype "TYPE" for column "SUB_TYPE" in table "dbo.ITEM_DESCRIPTION_TYPE" reverse engineered as VARCHAR(255)

Oddly the 'Source Type' for SUB_TYPE is listed as VARCHAR(255) Manual editing screen.

And finally at the migration stage it fails the whole table with
ERROR: `prod_talis`.`ITEM_DESCRIPTION_TYPE`:Type mismatch fetching field 2 (should be char, was MYSQL_TYPE_STRING)

Any idea what we can do here?
It looks like the issue is identifying field data types correct in Sybase. It's also odd that the process refers to the same SOURCE field as "TYPE, VARCHAR and char".
With hundreds of tables and thousands of fields this will be very tricky to resolve manually.

Any pointers appreciated?!

Kind Regards
Chris Keene

MySQL Workbench ERROR: General error: triggers and procedures not supported in runtime engine (2 replies)

Mikh Mikhailov — Wed, 18 Sep 2013 09:34:26 +0000

Hi

I try do export from: Sybase SQL Anywhere Database Engine Version 5.5 to MySQL
I use MySQL Workbench 6.0.7

In step ...Fetching schema names, error has occurred:
-----
SystemError: Error("('HY000', '[HY000] [Sybase][ODBC Driver]General error: triggers and procedures not supported in runtime engine (-275) (SQLExecDirectW)')"): error calling Python module function DbSQLAnywhereRE.getSchemaNames

ERROR: Retrieve schema list from source: Error("('HY000', '[HY000] [Sybase][ODBC Driver]General error: triggers and procedures not supported in runtime engine (-275) (SQLExecDirectW)')"): error calling Python module function DbSQLAnywhereRE.getSchemaNames

Failed
-----

Help please

How-To: Database Migration from Sybase Adaptive Server Enterprise using MySQL Workbench (no replies)

Edwin Desouza — Tue, 06 Aug 2013 16:44:01 +0000

Sybase ASE migration:
http://mysqlworkbench.org/2013/08/how-to-database-migration-from-sybase-adaptive-server-enterprise-using-mysql-workbench/

Sybase to MySQL (4 replies)

James Tow — Fri, 12 Jul 2013 10:16:16 +0000

We have several flavors of databases where I work and they all talk to each other. Currently, we have a Sybase database talking to a MySQL database. MySQL is the destination. To make a long story short, I need to "re-seed" the data on MySQL with data from Sybase. Here is what I am going to do.

The table in question is using the MyISAM engine.

1. BCP data from Sybase to text file - it will be about 14GB+ as it has images in the table.

2. Create a temp staging table on MySQL on production.

3. Load the data into the staging table on MySQL in production.

4. Rename the current MySQL production table to TableName_Backup and rename the staging table to the production table name.

I am doing the rename option because an insert/update/delete with this table is near impossible with the BLOB data that is stored with it. I did some tests on development and it was taking more than 18 hours to run an update of just a few columns - excluding the BLOB columns. When I did the rename option on development, it took seconds to execute the SQL.

Thank you for your patience in reading my post so far.

My questions are as follows: Is this a valid way to accomplish the task of re-seeding data like this? Will there be any issues with the MyISAM engine doing the rename table method?

What advice or caution can you provide?

Thank you in advance for your time and consideration.

James

How-To: Database Migration from Sybase SQLAnywhere using MySQL Workbench (no replies)

Edwin Desouza — Tue, 25 Jun 2013 19:53:27 +0000

Sybase SQL Anywhere migration:
http://mysqlworkbench.org/2013/06/how-to-database-migration-from-sybase-sqlanywhere-using-mysql-workbench/

How-To: Database Migration from Sybase SQLAnywhere using MySQL Workbench (no replies)

Edwin Desouza — Tue, 25 Jun 2013 19:53:00 +0000

Sybase SQL Anywhere migration:
http://mysqlworkbench.org/2013/06/how-to-database-migration-from-sybase-sqlanywhere-using-mysql-workbench/

Database Migration: Sybase to MySQL (no replies)

Edwin Desouza — Wed, 21 Nov 2012 16:34:46 +0000

MySQL Workbench: Database Migration
- Download: http://dev.mysql.com/downloads/workbench/
- Docs: http://dev.mysql.com/doc/workbench/en/wb-migration.html

Sybase ASE migration:
https://dev.mysql.com/blog-archive/how-to-database-migration-from-sybase-adaptive-server-enterprise-using-mysql-workbench/

Sybase SQL Anywhere migration:
https://dev.mysql.com/blog-archive/how-to-database-migration-from-sybase-sqlanywhere-using-mysql-workbench/

connect sql server (no replies)

Sabareesh raj — Sat, 08 Sep 2012 12:40:04 +0000

how to connect sql server 2005 with vb.net

Can't connect to Sql Anywhere 12 (4 replies)

Wayne Gregg — Wed, 02 May 2012 22:54:56 +0000

I have been working on updating a very old server and software. The origional install used SQL Anywhere 5. I managed to get the database converted and working in the development version of SQL Anywhere 12. I want to convert the database to work with MySQL but I cannot get the migration tool to connect. I dont know of any other way to do this.

The error:
Fetching of list failed.
SQL Anywhere Error -110:Item 'jtds000001'Already exists.

I have no clue what that means or how to fix it.
Help Please

Insert Ignore / On Duplicate Key - Conversion (7 replies)

Jim Taylor — Tue, 28 Feb 2012 07:17:21 +0000

I am in the middle of converting an application from using SQLAnywhere and trying to figure out the best way to adjust for a very useful feature in SQLAnywhere. For insert there is an "On EXISTING" feature where one can ERROR, SKIP or UPDATE. For most situations the Insert Ignore and On Duplicate works okay. Where I am having trouble are cases where I am doing something like:

insert into table_name (id, name, address) values select id, name, address from table_name2

and I want update if it already exists. Am I missing some functionality that would allow me to have it update based on my select list? Or, my update list itself instead of having to repeat stuff using ON DUPLICATE KEY? While the ON DUPLICATE KEY provides some flexibility that SQLAnywhere doesn't have it is also far more unwieldy when I simply want to update with the data provided in the insert values. Which is normally the case.

Obviously I may just be overlooking something.

Thank you for any suggestions you can provide.

Jim

DBA Sybase job opportunity Mexico (no replies)

Olivia Galindo — Thu, 10 Nov 2011 22:01:57 +0000

We need a DBA Sybase for Guadalajar Mexico, he might have 2 years of experience or more and is a full time position.

good salary plus benefits.

Sybase ASE 11.9.2.6 for HPUX (no replies)

Matt Mendoza — Tue, 16 Aug 2011 09:16:44 +0000

Hi,

i am looking for an installer of Sybase ASE 11.9.2.6 for HP-UX ...
i tried buying from the local distributor but he can only give me the latest version ...
any idea how i can get a copy?

thanks.

SYBASE to MYSQL (1 reply)

Aditya Y — Fri, 19 Aug 2011 15:40:20 +0000

Hi All,

We are planning to migrate existing SYBASE databases to MYSQL, If any one has done this, please let me know what methods/tools you have used.

Thank you,
Aditya

Error in Using XMLTable function (no replies)

Siddharth Singh — Thu, 14 Jul 2011 14:22:26 +0000

Hi Everyone,

I am using ASE 15.0 and connected to Sybase DB.

I want to use XMLTable() to load an XML file to a table.
Since I am using below query for testing it's not working:

select * from xmltable('/doc/item'
passing '1Box'
+'2Jar'
columns id int path 'id',name varchar(20) path 'name') as items_table

Error: 11:52:07 [SELECT - 0 row(s), 0.000 secs] [Error Code: 102, SQL State: 37000] Incorrect syntax near '('.
... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec [0 successful, 0 warnings, 1 errors]

Any help regarding this issue its killing me.
I have enable the xml using sp_configure to "1";

Thanks in Advance,
Siddharth

a mistake is taken place in my site (no replies)

Wu Liming — Thu, 07 Apr 2011 09:59:06 +0000

my site is lacoste polo, sometimes it pills put aa alert sql mistake, what is up??

Migrate Sybase data to MYSql (1 reply)

karen jones — Fri, 25 Feb 2011 09:27:42 +0000

Hi

Trying to find out what tool/version I need to download in order to migrate Sybase data to MYSQL.

Any help would be appreciated

Thanks!
Karen

Calling Procedure from a Select (no replies)

Eric Hofer — Sun, 10 Oct 2010 08:42:12 +0000

I'm considering migrating to MySql from Sybase and am stumped. I too have many stored procedures that are used in other selects, for example:-

select UT.idUser, UT.nmUser, X.report
from Usertable UT
join MyProc () as X on X.idUser = UT.idUser

I see one bright spark suggested turning this into a function. Aside from the amount of work that would entail and inefficiency, it completely misses the point that MyProc returns several rows and serves as a wrapper for some complex processing that I don't want to have to 're-engineer'.

With "MyProc" returning a table, I can join on it, apply predicates, etc. I fail to see how that works in MySql. Or even why it's not implemented.

Anybody with any thoughts on this matter?

pls help: "identify" property after migration (2 replies)

S T Wong — Tue, 20 Jul 2010 14:19:08 +0000

Hi all,

I'm newbie to both Sybase and MySQL. We recently migrated a Sybase DB to MySQL using MySQL migration toolkit. The migration was smooth except for the "identify" data type in Sybase, which can't be converted successfully. Seems there is no equivalent data type in MySQL. Sorry that I've no idea about how to resolve the problem.

Would anyone please help?
Thanks a lot.
/ST Wong

SQL statment from Sybase SqlAnywhere 11 to MySql (1 reply)

Alex Declent — Sun, 18 Jul 2010 12:53:30 +0000

Is there a possibility to convert these SQL statment from Sybase to mySQL.

update PERSON_GROUP, PERSON_TO_DEPARTMENT
set fk_person_group =
(
select id from PERSON_CODE as t1 where
IMP_PERSON_TO_DEPARTMENT.dep_code is not null and
t1.per_code = IMP_PERSON_TO_DEPARTMENT.dep_code
)
where
IMP_PERSON_TO_DEPARTMENT.dep_code is not null
and PERSON_CODE.per_code = IMP_PERSON_TO_DEPARTMENT.per_code;

I have tried it with temporary tables and much more, but I'm ended with the error: Subquery returns more the one row.

best regards, Alex

Information needed for conformance testing - Sybase to SQL 2008 migration (no replies)

M J — Fri, 05 Feb 2010 14:28:14 +0000

Hi,

We have recently migrated from Sybase to SQL 2008. I want to know what are the best practices to test for conformance after the migration:
1. What are the areas that needs to be tested to ensure that migration does not break original features.
2. What are the broad areas that need to be tested?
3. Are there any tools available that can give us the detailed report on the issues stated above?

Thanks in Advance.

Some tool which converts Sybase ASA/ASE database to MySQL Database vice versa. (no replies)

Jenny M — Mon, 25 Jan 2010 10:12:02 +0000

NewsGroup: sybase.public.powerbuilder.database
Date: Jan 24,2010 10:46 pm
Created by: Jenny
Topic: Some tool which converts ASA/ASE database to MySQL Database vice versa.

Hi All,

Some tool which converts Sybase ASA/ASE database to MySQL Database
vice versa.

[1]
We have one project requirement; we are looking for some
tool which converts ASA11 database to MySQL Database.
Is any tool is available, some free tools is first
preference.

[2]
If I have to develop tool then, anyone have idea, how I can
do this ?? please guide me in details.
Thanks,
Jenny

Some tool which converts Sybase ASA/ASE database to MySQL Database vice versa. (no replies)

Jenny M — Mon, 25 Jan 2010 10:11:52 +0000

set multiple element from select in procedure stored (1 reply)

Xavier Manach — Wed, 23 Dec 2009 10:54:29 +0000

Hi.

I search a better way for my translation into a procedure stored.

First step : how to set 2 variables from a 'select'.

Sybase :
declare a smallint;
declare b smallint;
select a=col_a, b=col_b from my_table where col_c=1;

mysql solution 1 ... not good because I need to request 2 time :
declare a smallint;
declare b smallint;
set a =select (col_a from my_table where col_c=1);
set b =select (col_b from my_table where col_c=1);

mysql solution 2 ... use a cursor... it's the correct way ?:
declare a smallint;
declare b smallint;
DECLARE cur1 CURSOR FOR col_a, col_b from my_table where col_c=1;
OPEN cur1;
FETCH cur1 INTO a, b;
CLOSE cur1;

There is a best way or shortest way ?

Second Step : how test if exist a line.

Sybase :
declare a smallint;
declare b smallint;
select a=coalesce(col_a,0) , b=coalesce(col_b,0) from my_table where col_c=1;

mysql solution 1 ... not good because I need to request 2 time :
declare a smallint;
declare b smallint;
set a =select (coalesce(col_a,0) from my_table where col_c=1);
set b =select (coalesce(col_b,0) from my_table where col_c=1);

mysql solution 2 ... ??? :
declare a smallint;
declare b smallint;
declare done smallint default 0;
DECLARE cur1 CURSOR FOR col_a, col_b from my_table where col_c=1;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
OPEN cur1;
if (done=0) then
FETCH cur1 INTO a, b;
else;
set a=0;
set b=0;
end if;
CLOSE cur1;

Thx.
Xavinsky.

Data truncated while loading (2 replies)

Harirpiya Vedula — Mon, 04 Jan 2010 13:43:32 +0000

hi,

I have exported tables data from sybse to CSV file. and run the laod command LOAD DATA LOCAL INFILE './path.INTO TABLE table name FIELDS TERMINATED BY '|' ENCLOSED BY '' LINES TERMINATED BY '\r\n'(columns);

for some of the tables it worked fine.but for some tables where column data is more, it came to three lines. so it has taken second line as another record.

for example:

3 | 194 | 1 | Need Quote | per Rich's specifications in phone msg of 9/20/2001. Lump at 23, in between payments and retirment payments, 3 options using $240,000 per child | 2001-09-25 00:00:00.0 | N/A | Yes | null | null | 1 | Normal | null

i want this to be inserted in one single row.

thanks in advance....

How To get the Number of rows scan less when we take difference between the dates (no replies)

Amit Tripathi — Thu, 01 Oct 2009 05:32:26 +0000