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.

Tool to migrate from MS SQL -> Sybase SQL?

3 posts in Windows NT Last posting was on 1998-02-21 12:52:59.0Z
Bas Posted on 1998-02-20 08:33:43.0Z
From: "Bas" <bas.kroes@object.nl>
Subject: Tool to migrate from MS SQL -> Sybase SQL?
Message-ID: <01bd3de3$f64799c0$9800a8c0@bas>
X-Newsreader: Microsoft Internet News 4.70.1155
Newsgroups: sybase.public.sqlserver.nt
Date: Fri, 20 Feb 1998 03:33:43 -0500
Lines: 5
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5166
Article PK: 1081246

Is there a simple tool (besides bcp) to move from Microsoft SQL Server to
Sybase SQL Server? If yes, where can I find it?

Thanks in advance,

Bas Kroes
Bas.Kroes@Object.Nl


Reinoud van Leeuwen Posted on 1998-02-20 12:23:44.0Z
Message-ID: <34ED75D0.52A1@sybase.com>
Date: Fri, 20 Feb 1998 13:23:44 +0100
From: Reinoud van Leeuwen <reinoud@sybase.com>
Organization: Sybase Inc.
X-Mailer: Mozilla 3.0 (Win95; I)
MIME-Version: 1.0
To: Bas <bas.kroes@object.nl>
Subject: Re: Tool to migrate from MS SQL -> Sybase SQL?
References: <01bd3de3$f64799c0$9800a8c0@bas>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 19
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5165
Article PK: 1081245


Bas wrote:
>
> Is there a simple tool (besides bcp) to move from Microsoft SQL Server to
> Sybase SQL Server? If yes, where can I find it?
>

When you're using an old version of Microsoft (4.x) you can upgrade it
to Sybase. I don't now if this is possible with newer versions too..

But on the other hand: it is not very difficult to generate a script to
bcp out and in all you tables. When you want to move your model from MS
to Sybase there are a number of options:
- re run your old creation scripts (you can create those somewhere in
the MS Management tool)
- reverse engineer the datamodel with a tool like PowerDesigner

Reinoud van Leeuwen
Sybase Professional Services Maarssen / The Netherlands


Vitaly Lipovetsky Posted on 1998-02-21 12:52:59.0Z
From: "Vitaly Lipovetsky" <vit@fuib.com>
References: <01bd3de3$f64799c0$9800a8c0@bas> <34ED75D0.52A1@sybase.com>
Subject: Re: Tool to migrate from MS SQL -> Sybase SQL?
Date: Sat, 21 Feb 1998 14:52:59 +0200
Lines: 33
X-Newsreader: Microsoft Outlook Express 4.71.1712.3
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Message-ID: <34eecd28.0@ifuib>
Newsgroups: sybase.public.sqlserver.nt
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com!ifuib!172.17.3.101
Xref: forums-1-dub sybase.public.sqlserver.nt:5162
Article PK: 1081242


Reinoud van Leeuwen wrote in message <34ED75D0.52A1@sybase.com>...
>Bas wrote:
>>
>> Is there a simple tool (besides bcp) to move from Microsoft SQL Server to
>> Sybase SQL Server? If yes, where can I find it?
>>
>
>When you're using an old version of Microsoft (4.x) you can upgrade it
>to Sybase. I don't now if this is possible with newer versions too..
>
>But on the other hand: it is not very difficult to generate a script to
>bcp out and in all you tables. When you want to move your model from MS
>to Sybase there are a number of options:
>- re run your old creation scripts (you can create those somewhere in
>the MS Management tool)

You can't to use scripts from MS EM directly.
For example Syntax for creating default is different in MS and SYB.
In MS I can to create int identity but in SYB not.
In MS I can to execute UPDATE a
SET a.col1 = b.col1
FROM t1 a, t2 b
WHERE a.id = b.id
but in SYB not. Etc ...

I wrote special utility to convert scripts from MS EM to SYB.

>- reverse engineer the datamodel with a tool like PowerDesigner
>
>Reinoud van Leeuwen
>Sybase Professional Services Maarssen / The Netherlands