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.

SQL Anywhere to Sybase SQL Server

4 posts in ,  Upgrades and ConfigurationGeneral DiscussionGeneral DiscussionWindows NT Replication Last posting was on 1997-12-30 08:25:14.0Z
Michael Rosner Posted on 1997-12-24 17:16:17.0Z
Message-ID: <34A14361.B4BC2DE8@gigawatt.com>
Date: Wed, 24 Dec 1997 12:16:17 -0500
From: Michael Rosner <mrosner@gigawatt.com>
Organization: .
X-Mailer: Mozilla 4.04 [en] (Win95; I)
MIME-Version: 1.0
Subject: SQL Anywhere to Sybase SQL Server
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.general,sybase.public.sqlserver.nt,sybase.public.sqlserver.upgrades+configuration,sybase.public.distdir,sybase.public.sqlanywhere.replication,sybase.public.sqlanywhere.general
Lines: 11
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.general:194 sybase.public.sqlserver.nt:196 sybase.public.sqlserver.upgrades+configuration:131 sybase.public.distdir:162 sybase.public.sqlanywhere.replication:152 sybase.public.sqlanywhere.general:356
Article PK: 878965

We are considering upscaling part of our distributed SQL Anywhere
database to Sybase SQL Server or Adaptive Server. Does anyone know of a
reference (technical document, white paper, etc.) that addresses data
migration and/or replication issues between the two? Or how about some
words of encouragement (or discouragement) from anyone who's tried?

Much thanks for any info.

--Michael


Leo Tohill Posted on 1997-12-24 20:21:37.0Z
From: leotohill@csi.com (Leo Tohill)
Subject: Re: SQL Anywhere to Sybase SQL Server
Date: Wed, 24 Dec 1997 20:21:37 GMT
Message-ID: <34a1558b.4826399@forums.powersoft.com>
References: <34A14361.B4BC2DE8@gigawatt.com>
X-Newsreader: Forte Free Agent 1.1/32.230
Newsgroups: sybase.public.sqlserver.general,sybase.public.sqlserver.nt,sybase.public.sqlserver.upgrades+configuration,sybase.public.distdir,sybase.public.sqlanywhere.replication,sybase.public.sqlanywhere.general
Lines: 14
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.general:193 sybase.public.sqlserver.nt:195 sybase.public.sqlserver.upgrades+configuration:130 sybase.public.distdir:161 sybase.public.sqlanywhere.replication:151 sybase.public.sqlanywhere.general:355
Article PK: 878964


>We are considering upscaling part of our distributed SQL Anywhere
>database to Sybase SQL Server or Adaptive Server. Does anyone know of a
>reference (technical document, white paper, etc.) that addresses data
>migration and/or replication issues between the two? Or how about some
>words of encouragement (or discouragement) from anyone who's tried?

The SQL Anywhere online help has an extensive section on
compatability.


Leo Tohill - Team Powersoft
-- Please post in newsgroup, not via email <


Grant Queenin Posted on 1997-12-30 08:25:14.0Z
From: "Grant Queenin" <grantq@sybase.com>
References: <34A14361.B4BC2DE8@gigawatt.com> <34a1558b.4826399@forums.powersoft.com>
Subject: Re: SQL Anywhere to Sybase SQL Server
Date: Tue, 30 Dec 1997 19:25:14 +1100
Lines: 52
X-Newsreader: Microsoft Outlook Express 4.71.2038.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.2039.0
Message-ID: <51$yzOPF9GA.189@forums.powersoft.com>
Newsgroups: sybase.public.sqlserver.general,sybase.public.sqlserver.nt,sybase.public.sqlserver.upgrades+configuration,sybase.public.distdir,sybase.public.sqlanywhere.replication,sybase.public.sqlanywhere.general
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.general:192 sybase.public.sqlserver.nt:194 sybase.public.sqlserver.upgrades+configuration:129 sybase.public.distdir:160 sybase.public.sqlanywhere.replication:150 sybase.public.sqlanywhere.general:354
Article PK: 878963

Sybase Central will convert anything that has a direct TSQL equiv. so far as
sp's and triggers go (right click and open as TSQL) and it comments out
anything that it can't convert.

The default transaction mode in SQLA is different to ASE/SS.

Some datatypes in SQLA are not available in ASE/SS so you need to work
around these or declare synonym types to shadow these - watch for reserved
words!

Be cautious when converting physical data model in ERD type tools many do
not pick up things like varchar(512) and tell you that this is not supported
in ASE/SS. A big VARCHAR field (> 254 bytes) is the biggest worry for anyone
upsizing from SQLA -> ASE. SQLA allows TEXT to be passed around as a
parameter with sp's and allows manipulation within these. ASE does not, so
backend text manipulation must be done via ESP's or moved client side. We've
done this for a client in Sydney with great success.

Data migration can be achieved a number of ways ranging from export/import
Infomaker/PowerBuilder pipelines etc through to replication. We have found
that with a little playing around (principally creating a non-existent sp's
in SQLA) it is possible to get the Open Server SQLA gateway to work as a
homogenous data source for ASE enabling SELECT INTO's to be used via the
Component Integration Services available in ASE. Do not take this as an
endorsement of the approach - but it saved us a lot of manual coding as we
simply wrote a meta query to generate the select into's for us and in turn
ran the result!

I hope this is of some value.

Regards
Grant Queenin
Practice Manager, Professional Services
Sybase Australia

Leo Tohill wrote in message <34a1558b.4826399@forums.powersoft.com>...
>>We are considering upscaling part of our distributed SQL Anywhere
>>database to Sybase SQL Server or Adaptive Server. Does anyone know of a
>>reference (technical document, white paper, etc.) that addresses data
>>migration and/or replication issues between the two? Or how about some
>>words of encouragement (or discouragement) from anyone who's tried?
>
>
>The SQL Anywhere online help has an extensive section on
>compatability.
>
>
>Leo Tohill - Team Powersoft
>-- Please post in newsgroup, not via email <


Dinyar Ghyara Posted on 1997-12-27 16:52:20.0Z
Message-ID: <34A53244.F0C50D6C@rocketmail.com>
Date: Sat, 27 Dec 1997 22:22:20 +0530
From: Dinyar Ghyara <dinyar@rocketmail.com>
X-Mailer: Mozilla 4.03 [en] (Win95; I)
MIME-Version: 1.0
To: Michael Rosner <mrosner@gigawatt.com>
Subject: Re: SQL Anywhere to Sybase SQL Server
References: <34A14361.B4BC2DE8@gigawatt.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlanywhere.general
Lines: 45
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlanywhere.general:72902
Article PK: 936339

Hi,
I don't know of a technical ref but here are a set of possible problems,
if I remember correctly the foreign key declaration syntax is different,
if u have used SSA's sql for joins like KEY JOIN etc. u will have trouble
if u have used SSA's trigger options like row level triggers/before triggers
etc. u will have trouble

solution
for your procedures and triggers use sql central to translate the procedures
and triggers to t-sql - it has the option
if u have PowerBuilder - use it's pipeline feature to pipeline the data to
sybase
u could also use S-Designor or PowerDesignor as it is now called to reverse
engineer your database and translate the script to Sybase - but i would
recommend against it if u have many foreign keys, because i have seen it add
additional columns to tables etc. where foreign keys and joins are defined-i
may have missed out on some setting which would turn the behavoiout off - if
u find it do let me know
all this was under the assumption that u have SSA for win 95 or NT and have
sql central and have PB and S-D

as for replication between SSA to Sybase and back is not a problem from what
i have seen. (i have'nt tied it though. i would if u wnat me to tell u how
it can be done)

but as far as i can remember it is quite an easy task.
best of luck
-dinyar

Michael Rosner wrote:

> We are considering upscaling part of our distributed SQL Anywhere
> database to Sybase SQL Server or Adaptive Server. Does anyone know of a
> reference (technical document, white paper, etc.) that addresses data
> migration and/or replication issues between the two? Or how about some
> words of encouragement (or discouragement) from anyone who's tried?
>
> Much thanks for any info.
>
> --Michael