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.

Migration tipos:- SQL Server 2000 to SYBASE Anywhere?

5 posts in General Discussion Last posting was on 2003-08-13 23:34:36.0Z
VBM Posted on 2003-08-13 16:54:00.0Z
From: "VBM" <legendnews@lycos.co.uk>
Newsgroups: ianywhere.public.general
Subject: Migration tipos:- SQL Server 2000 to SYBASE Anywhere?
Lines: 13
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 12.25.165.67
X-Original-NNTP-Posting-Host: 12.25.165.67
Message-ID: <3f3a6d28$1@forums-1-dub>
Date: 13 Aug 2003 09:54:00 -0700
X-Trace: forums-1-dub 1060793640 12.25.165.67 (13 Aug 2003 09:54:00 -0700)
X-Original-Trace: 13 Aug 2003 09:54:00 -0700, 12.25.165.67
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1593
Article PK: 3822

Hello,

I have a web application. I want this to be ported on different databases.
To test this I want to try my existigng SQL Server database to be migrated
on Sybase Anywhere (7.04). Is there handly tool/procedure/method to convert
SQL Server 2000 databases , store procs to SYBASE Anywhere 7.04!

I am using uniqueidentifier datatype in SQL Server , is there anything
equivalent in Sybase. How should I proceed on this migration?

thanks in advance


Alistair Hayward Posted on 2003-08-13 20:52:58.0Z
From: "Alistair Hayward" <alistair@co-sys.co.nz>
Newsgroups: ianywhere.public.general
References: <3f3a6d28$1@forums-1-dub>
Subject: Re: Migration tipos:- SQL Server 2000 to SYBASE Anywhere?
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 210.55.187.50
X-Original-NNTP-Posting-Host: 210.55.187.50
Message-ID: <3f3aa52a$1@forums-1-dub>
Date: 13 Aug 2003 13:52:58 -0700
X-Trace: forums-1-dub 1060807978 210.55.187.50 (13 Aug 2003 13:52:58 -0700)
X-Original-Trace: 13 Aug 2003 13:52:58 -0700, 210.55.187.50
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1597
Article PK: 3826

I have just exported my existing SQL database to Sybase by creating a blank
database in Sybase Central, then using the export function in SQL Server to
export the data and tables...

"VBM" <legendnews@lycos.co.uk> wrote in message
news:3f3a6d28$1@forums-1-dub...
> Hello,
>
> I have a web application. I want this to be ported on different databases.
> To test this I want to try my existigng SQL Server database to be migrated
> on Sybase Anywhere (7.04). Is there handly tool/procedure/method to
convert
> SQL Server 2000 databases , store procs to SYBASE Anywhere 7.04!
>
> I am using uniqueidentifier datatype in SQL Server , is there anything
> equivalent in Sybase. How should I proceed on this migration?
>
> thanks in advance
>
>


VBM Posted on 2003-08-13 21:57:23.0Z
From: "VBM" <legendnews@lycos.co.uk>
Newsgroups: ianywhere.public.general
References: <3f3a6d28$1@forums-1-dub> <3f3aa52a$1@forums-1-dub>
Subject: Re: Migration tipos:- SQL Server 2000 to SYBASE Anywhere?
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: 12.25.165.67
Message-ID: <3f3ab446$1@forums-2-dub>
X-Original-Trace: 13 Aug 2003 14:57:26 -0700, 12.25.165.67
NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
Date: 13 Aug 2003 14:57:23 -0700
X-Trace: forums-1-dub 1060811843 10.22.241.42 (13 Aug 2003 14:57:23 -0700)
X-Original-Trace: 13 Aug 2003 14:57:23 -0700, forums-2-dub.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1598
Article PK: 3827

whats the best datatype to export uniqueidentifier type of data...
what should be the size of that data type

Alistair Hayward wrote:
> I have just exported my existing SQL database to Sybase by creating a
> blank database in Sybase Central, then using the export function in
> SQL Server to export the data and tables...
>
> "VBM" <legendnews@lycos.co.uk> wrote in message
> news:3f3a6d28$1@forums-1-dub...
>> Hello,
>>
>> I have a web application. I want this to be ported on different
>> databases. To test this I want to try my existigng SQL Server
>> database to be migrated on Sybase Anywhere (7.04). Is there handly
>> tool/procedure/method to convert SQL Server 2000 databases , store
>> procs to SYBASE Anywhere 7.04!
>>
>> I am using uniqueidentifier datatype in SQL Server , is there
>> anything equivalent in Sybase. How should I proceed on this
>> migration?
>>
>> thanks in advance


Alistair Hayward Posted on 2003-08-13 22:52:56.0Z
From: "Alistair Hayward" <alistair@co-sys.co.nz>
Newsgroups: ianywhere.public.general
References: <3f3a6d28$1@forums-1-dub> <3f3aa52a$1@forums-1-dub> <3f3ab446$1@forums-2-dub>
Subject: Re: Migration tipos:- SQL Server 2000 to SYBASE Anywhere?
Lines: 31
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 210.55.187.50
X-Original-NNTP-Posting-Host: 210.55.187.50
Message-ID: <3f3ac148$1@forums-1-dub>
Date: 13 Aug 2003 15:52:56 -0700
X-Trace: forums-1-dub 1060815176 210.55.187.50 (13 Aug 2003 15:52:56 -0700)
X-Original-Trace: 13 Aug 2003 15:52:56 -0700, 210.55.187.50
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1599
Article PK: 3828

I used Char with size of 10

"VBM" <legendnews@lycos.co.uk> wrote in message
news:3f3ab446$1@forums-2-dub...
> whats the best datatype to export uniqueidentifier type of data...
> what should be the size of that data type
>
>
> Alistair Hayward wrote:
> > I have just exported my existing SQL database to Sybase by creating a
> > blank database in Sybase Central, then using the export function in
> > SQL Server to export the data and tables...
> >
> > "VBM" <legendnews@lycos.co.uk> wrote in message
> > news:3f3a6d28$1@forums-1-dub...
> >> Hello,
> >>
> >> I have a web application. I want this to be ported on different
> >> databases. To test this I want to try my existigng SQL Server
> >> database to be migrated on Sybase Anywhere (7.04). Is there handly
> >> tool/procedure/method to convert SQL Server 2000 databases , store
> >> procs to SYBASE Anywhere 7.04!
> >>
> >> I am using uniqueidentifier datatype in SQL Server , is there
> >> anything equivalent in Sybase. How should I proceed on this
> >> migration?
> >>
> >> thanks in advance
>
>


"Richard Biffl" Posted on 2003-08-13 23:34:36.0Z
From: "Richard Biffl" <sybaseforums a t removvethiisphrraseblacklettersoftware dot com>
Newsgroups: ianywhere.public.general
References: <3f3a6d28$1@forums-1-dub> <3f3aa52a$1@forums-1-dub> <3f3ab446$1@forums-2-dub>
Subject: Re: Migration tipos:- SQL Server 2000 to SYBASE Anywhere?
Lines: 13
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: user-112ut0j.biz.mindspring.com
X-Original-NNTP-Posting-Host: user-112ut0j.biz.mindspring.com
Message-ID: <3f3acb0c$1@forums-1-dub>
Date: 13 Aug 2003 16:34:36 -0700
X-Trace: forums-1-dub 1060817676 66.47.116.19 (13 Aug 2003 16:34:36 -0700)
X-Original-Trace: 13 Aug 2003 16:34:36 -0700, user-112ut0j.biz.mindspring.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1602
Article PK: 3829

SQL Anywhere 9 creates domains:

uniqueidentifier = binary(16)
uniqueidentifierstr = char(32)

Richard

"VBM" <legendnews@lycos.co.uk> wrote in message
news:3f3ab446$1@forums-2-dub...
> whats the best datatype to export uniqueidentifier type of data...
> what should be the size of that data type