MySQL Forums - Sybase

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
- Migration from Sybase ASE (versions: )

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 (4 replies)

karen jones — Fri, 20 May 2011 18:53:47 +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)

ST 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

Migration toolkit custom datatype (no replies)

Mike WALDMAN — Thu, 20 Aug 2009 14:06:28 +0000

Hello,

I'm trying to migrate a sybase ASE DB to MySQL.
I have a custom datatype in sybase, which cause the migration to fail. I know that mysql doesn't support custom datatype, how can I tell the toolkit that the custom datatype should be replaced by the corresponding type?

Thanks for the help!

Mike

Getting updated rowcount in Powerbuilder (4 replies)

Shawn Pleska — Tue, 29 Sep 2009 20:45:42 +0000

I'm issuing an embedded update in my code and I need to be sure the proper number of rows have been updated. Using the transaction management variable SQLNRows, when updating to Sybase ASE I used to be able to check this value for the update rowcount. For instance, if 1 row was updated, the value would be 1. If no rows were updated, the value would be zero. In my transition to MySQL, I've noticed that the same result is not being returned. For instance, in my testing I've learned that when the embedded update causes no rows to be updated, the value in SQLNRows is 1 when my code expects the value to be zero. That of course causes BIG problems. It seems to me like a success/failure code is being returned in SQLNRows rather than an update rowcount.

Is there a configuration setting or a database parameter that would make the value returned to Powerbuilder from MySQL in the SQLNRows transaction variable be the number of rows updated?

Thanks,
Shawn

ODBC Remotely (no replies)

Mariam Adel — Thu, 02 Jul 2009 15:03:29 +0000

Please I would like to know how to fill the ODBC form to connect on the database I created on mysql on my domain on yahoo .

Thanks in advance .

Re: voice broadcasting (-1 replies)

Mark 2009 — Wed, 10 Jun 2009 07:54:24 +0000

Hi,

Thanks for sharing the information.

Voice broadcasting system is undoubtedly a positive innovation. It is very useful for both the business or community purposes. Through these telephonic equipments, voice broadcasters can contact with the people from the contact list such as- buyers, suppliers, employees, members or customers and access them in a second.
There are many sites which provide valuable information on voice broadcast system.

database consistency check command in mysql (no replies)

Muslim Abdul KADER — Fri, 24 Apr 2009 21:40:02 +0000

Like in Sybase's "dbcc checktable(table_name)" which gives the logical pagesize and data pages of a table, how do i find the logical pagesize and data pages of a MySQL table.

SELECT statement that should not return the "XXX rows affected line" (1 reply)

Muslim Abdul KADER — Sat, 25 Apr 2009 16:43:17 +0000

I need to write a select statement, that should produce just the output and should not show up the "no of rows affected" in its output.
for example

1> select * from Tester

TesterId TestCompId TestprovId -----------
0 0 0
2280638 2280638 1000
2280639 2280639 1000
2280640 2280640 1000
2280641 2280641 1000
2280642 2280642 2000
2280643 2280643 2000
2280644 10270970 1000
2280645 2280645 2000
2280646 2280646 2000
5300522 5300522 2000
5300523 5300523 2000
5300524 5300524 2000
5309074 5309074 2000
5573907 5573907 2000
5909156 5909156 1000
5915339 5915339 1000
6879589 6879589 1000
8155084 8155092 2000
10270973 10270973 1000
12746835 12746837 1000
14197273 14197273 1000

(22 rows affected)

I do not want the (22 rows affected) line. What do i need to add in the select statement to eliminate this?

set nocount equivalent (1 reply)

Muslim Abdul KADER — Wed, 06 May 2009 15:57:53 +0000

In my existing application that uses sybase, i have "set nocount on" to disable the count of rows displayed out of a select statement.

Now, that we are migrating to MySQL and i cannot use "set nocount on", is there a way that i can implement on MySQL that provides the same functionality as "set nocount on". ?

Line Brek Problem while migrating. (no replies)

Noah Selva Raj — Wed, 18 Feb 2009 10:52:12 +0000

After we'd sucessfully migrated from Sybase ASA, but after that we found instead of Link Break here its added with x0dx0a. Please anybody advice us how to avoid this while migrating

Capture Live Web Data (no replies)

Snow Man — Thu, 27 Nov 2008 01:34:11 +0000

Is there a method for capturing live data from a foreign web site similar to this method in SyBase?

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.stf.help.mb/mb000000150.html

Alternate Suggestions or Reading?

Thanks!

Where is the storage place in sybase? (1 reply)

Mathan K — Mon, 11 May 2009 04:43:12 +0000

Hi Friends,
This is Mathan. I am new to Sybase and this Forum.
I have some questions related sybase ct_lib API's.

Example:
Database.exec()
Database.bind()
Database.next()
Database.get_result()

when doing the above proceture, the query is sending to sybase via cl_lib. Sybase will fetch the records based on the query by user. Suppose here we have 10000 fetched records by sybase.
Now we can use get_result() method to get all the fetched records.

My question is:
1) Are fetched records stored in sybase end?
If yes, the ct_next() will call for every already fetched record and forward to application???
2) or ct_lib is maintaining any space to store all the fetched records.
If yes, can we get the all fetched records to application, when sybase is unavailable ?????

Please can anyone help me on this

/MaK

Sybase ASE to MySQL Migration Guide (no replies)

Rey Wang — Tue, 02 Sep 2008 03:21:08 +0000

Sybase web site has this, MySQL to Sybase ASE Migration Guide

http://www.sybase.com/detail?id=1051522

Any migration guide for ASE to MySQL, topics on dbcc, raw devices, sp_helpdb, engine configuration, shared memory configuration.

Thanks