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.

Error when migrating data from a Sybase DB to a SQL Express 2005

5 posts in General Discussion Last posting was on 2006-03-06 15:56:24.0Z
osman Posted on 2006-03-02 19:00:37.0Z
From: "osman" <ofarah@supra.com>
Newsgroups: ianywhere.public.general
Subject: Error when migrating data from a Sybase DB to a SQL Express 2005
Lines: 11
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
NNTP-Posting-Host: antibes.supralog.com
X-Original-NNTP-Posting-Host: antibes.supralog.com
Message-ID: <440740d5$1@forums-1-dub>
Date: 2 Mar 2006 11:00:37 -0800
X-Trace: forums-1-dub 1141326037 62.210.114.21 (2 Mar 2006 11:00:37 -0800)
X-Original-Trace: 2 Mar 2006 11:00:37 -0800, antibes.supralog.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5216
Article PK: 1276

Hi all,
I would like to migrate data from a Sybase DB to a SQL Express 2005 DB.
I am using pipelines for that and when I execute pipelines some of them rise
this error:
" SQLSTATE = 07006 [Microsoft][SQL Native Client] Violation of restricted
attribute data type ".
If someone has already resolved this kind of error, please tell me how.
Thank.
Osman.


Breck Carter Posted on 2006-03-02 19:53:56.0Z
From: Breck Carter <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Error when migrating data from a Sybase DB to a SQL Express 2005
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <i9fe029soot4ik9st19ms39cts7m4fevki@4ax.com>
References: <440740d5$1@forums-1-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
X-Original-Trace: 2 Mar 2006 10:47:43 -0800, bcarter.sentex.ca
Lines: 26
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 2 Mar 2006 10:47:44 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 2 Mar 2006 11:53:56 -0800
X-Trace: forums-1-dub 1141329236 10.22.108.75 (2 Mar 2006 11:53:56 -0800)
X-Original-Trace: 2 Mar 2006 11:53:56 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5217
Article PK: 1275

You need to investigate this further... there is probably some
unsupported difference between the data types used for some one column
on both sides of the transfer; e.g., you are pipelining a date to an
integer, something like that. Also, if the schema has changed for a
table, the corresponding pipeline may need to be recreated.

Breck

On 2 Mar 2006 11:00:37 -0800, "osman" <ofarah@supra.com> wrote:

>Hi all,
>I would like to migrate data from a Sybase DB to a SQL Express 2005 DB.
>I am using pipelines for that and when I execute pipelines some of them rise
>this error:
>" SQLSTATE = 07006 [Microsoft][SQL Native Client] Violation of restricted
>attribute data type ".
>If someone has already resolved this kind of error, please tell me how.
>Thank.
>Osman.
>

--
breck.carter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html


Breck Carter Posted on 2006-03-02 20:07:08.0Z
From: Breck Carter <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Error when migrating data from a Sybase DB to a SQL Express 2005
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <c4ge02plojkq21pngbe6krnigmtbma3lvs@4ax.com>
References: <440740d5$1@forums-1-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
X-Original-Trace: 2 Mar 2006 11:00:55 -0800, bcarter.sentex.ca
Lines: 23
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 2 Mar 2006 11:00:56 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 2 Mar 2006 12:07:08 -0800
X-Trace: forums-1-dub 1141330028 10.22.108.75 (2 Mar 2006 12:07:08 -0800)
X-Original-Trace: 2 Mar 2006 12:07:08 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5218
Article PK: 1277

Here is another thought: SQL Anywhere TIMESTAMP is *not* the same as
MSS TIMESTAMP; use MSS DATETIME instead.

Breck Just Guessing

On 2 Mar 2006 11:00:37 -0800, "osman" <ofarah@supra.com> wrote:

>Hi all,
>I would like to migrate data from a Sybase DB to a SQL Express 2005 DB.
>I am using pipelines for that and when I execute pipelines some of them rise
>this error:
>" SQLSTATE = 07006 [Microsoft][SQL Native Client] Violation of restricted
>attribute data type ".
>If someone has already resolved this kind of error, please tell me how.
>Thank.
>Osman.
>

--
breck.carter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html


André Schild Posted on 2006-03-02 21:48:35.0Z
From: André Schild <a.schild@aarboard.ch>
User-Agent: Mozilla Thunderbird 1.0.6 (X11/20050715)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Error when migrating data from a Sybase DB to a SQL Express 2005
References: <440740d5$1@forums-1-dub> <c4ge02plojkq21pngbe6krnigmtbma3lvs@4ax.com>
In-Reply-To: <c4ge02plojkq21pngbe6krnigmtbma3lvs@4ax.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: 212-41-71-206.adsl.solnet.ch
X-Original-NNTP-Posting-Host: 212-41-71-206.adsl.solnet.ch
Message-ID: <44076833@forums-1-dub>
Date: 2 Mar 2006 13:48:35 -0800
X-Trace: forums-1-dub 1141336115 212.41.71.206 (2 Mar 2006 13:48:35 -0800)
X-Original-Trace: 2 Mar 2006 13:48:35 -0800, 212-41-71-206.adsl.solnet.ch
Lines: 9
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5219
Article PK: 1278


Breck Carter wrote:
> Here is another thought: SQL Anywhere TIMESTAMP is *not* the same as
> MSS TIMESTAMP; use MSS DATETIME instead.
>

Autoincrement and default values also can cause problems.
Beside this, SQL 2005 is still very new and has several bugs in it...

André


Joshua Savill Posted on 2006-03-06 15:56:24.0Z
From: "Joshua Savill" <nospam_jsavill@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <440740d5$1@forums-1-dub>
Subject: Re: Error when migrating data from a Sybase DB to a SQL Express 2005
Lines: 20
Organization: iAnywhere Solutions
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
X-Original-NNTP-Posting-Host: jsavill-pc.sybase.com
Message-ID: <440c4c0c$1@forums-2-dub>
X-Original-Trace: 6 Mar 2006 06:49:48 -0800, jsavill-pc.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 6 Mar 2006 06:49:51 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 6 Mar 2006 07:56:24 -0800
X-Trace: forums-1-dub 1141660584 10.22.108.75 (6 Mar 2006 07:56:24 -0800)
X-Original-Trace: 6 Mar 2006 07:56:24 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5220
Article PK: 1279

Please do not cross post. This question has already been addressed in the
sybase.public.sqlanywhere.general newsgroup.

--
Joshua Savill
iAnywhere Solutions - Product Support Analyst

"osman" <ofarah@supra.com> wrote in message news:440740d5$1@forums-1-dub...
> Hi all,
> I would like to migrate data from a Sybase DB to a SQL Express 2005 DB.
> I am using pipelines for that and when I execute pipelines some of them
> rise this error:
> " SQLSTATE = 07006 [Microsoft][SQL Native Client] Violation of
> restricted attribute data type ".
> If someone has already resolved this kind of error, please tell me how.
> Thank.
> Osman.
>