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.

MS SQL 7 to ASA 8 migration

10 posts in General Discussion Last posting was on 2003-07-11 17:09:29.0Z
danrhcos Posted on 2003-07-07 21:24:02.0Z
From: danrhcos
Date: Mon, 7 Jul 2003 17:24:02 -0400
Newsgroups: ianywhere.public.general
Subject: MS SQL 7 to ASA 8 migration
Message-ID: <060BAD1B0CCF489C00758E9585256D5C.00758EC485256D5C@webforums>
Lines: 23
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:1285
Article PK: 3526

I am trying to migrate an MS SQL 7 database to ASA 8 and am having some
difficulty. Here is what I am experiencing.

MS SQL database is approx. 3.3 GB in size

My first attempt was run on a PIII 700 with 384 MB RAM. The migration took
about 18 hours to complete. The resulting database was 500MB in size

I then switched to a Dual Xeon 2.0GHz with 1024 MB RAM. The migration
never completed and after about 25 hours was only about one-third of the
way done. This doesn't make any sense to me since it appears that the
migration is CPU intenisve, so it should just fly......

All of my hardware has all of the latest updates, all of my software has
all of the latest updates. I have run all of the diagnostic/performance
tests on the hardware and it appears to be just fine.

Here are my questions:
1) any idea how long this migration should take?
2) any idea why it is dog slow on a dual Xeon machine?
3) is it normal to turn a 3.3GB database into 500MB ?

Any help would be appreciated.


Stephen Rice Posted on 2003-07-08 14:47:30.0Z
From: "Stephen Rice" <srice_nospam@ianywhere.com>
References: <060BAD1B0CCF489C00758E9585256D5C.00758EC485256D5C@webforums>
Subject: Re: MS SQL 7 to ASA 8 migration
Date: Tue, 8 Jul 2003 10:47:30 -0400
Lines: 49
Organization: iAnywhere Solutions
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
Message-ID: <uE#4$DWRDHA.358@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: srice-pc.sybase.com 172.31.142.125
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1287
Article PK: 3529

My first question is how are you migrating? Are you using Proxy tables or
flat files or....?

As for db size, I would not be shocked to find out ASA had a smaller
footprint than MSSQL. My, somewhat limited, understanding of ASE internals
would lead me to believe that this could happen if you had the right mixture
of data types and data (e.g. if you used allot of CHAR columns that tended
to actually contain significantly less data then the declared size)

/steve

--
Stephen Rice
Technical Services Manager
iAnywhere Solutions

- Please Post-
Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

<danrhcos> wrote in message
news:060BAD1B0CCF489C00758E9585256D5C.00758EC485256D5C@webforums...
> I am trying to migrate an MS SQL 7 database to ASA 8 and am having some
> difficulty. Here is what I am experiencing.
>
> MS SQL database is approx. 3.3 GB in size
>
> My first attempt was run on a PIII 700 with 384 MB RAM. The migration
took
> about 18 hours to complete. The resulting database was 500MB in size
>
> I then switched to a Dual Xeon 2.0GHz with 1024 MB RAM. The migration
> never completed and after about 25 hours was only about one-third of the
> way done. This doesn't make any sense to me since it appears that the
> migration is CPU intenisve, so it should just fly......
>
> All of my hardware has all of the latest updates, all of my software has
> all of the latest updates. I have run all of the diagnostic/performance
> tests on the hardware and it appears to be just fine.
>
> Here are my questions:
> 1) any idea how long this migration should take?
> 2) any idea why it is dog slow on a dual Xeon machine?
> 3) is it normal to turn a 3.3GB database into 500MB ?
>
> Any help would be appreciated.


danrhcos Posted on 2003-07-09 17:11:24.0Z
From: danrhcos
Date: Wed, 9 Jul 2003 13:11:24 -0400
Newsgroups: ianywhere.public.general
Subject: Re: MS SQL 7 to ASA 8 migration
Message-ID: <19482CA99BD8E718005E6D7685256D5E.0059380385256D5D@webforums>
References: <060BAD1B0CCF489C00758E9585256D5C.00758EC485256D5C@webforums> <uE#4$DWRDHA.358@forums-2-dub>
Lines: 1
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:1303
Article PK: 3537


danrhcos Posted on 2003-07-09 17:25:36.0Z
From: danrhcos
Date: Wed, 9 Jul 2003 13:25:36 -0400
Newsgroups: ianywhere.public.general
Subject: Re: MS SQL 7 to ASA 8 migration
Message-ID: <0592720AF081A486005FBA2A85256D5E.0059380385256D5D@webforums>
References: <060BAD1B0CCF489C00758E9585256D5C.00758EC485256D5C@webforums> <uE#4$DWRDHA.358@forums-2-dub>
Lines: 21
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:1304
Article PK: 3541

One more try on the response.....

I am migrating using the Migration Wizard. I am connecting to the MS SQL
database via ODBC. I have tried the migration with the MS SQL database on
the same machine as well as on a different machine....no difference in
performance. To me it appears to be an ASA issue.

I believe the Migration wizard is using proxy tables since it asks me if I
want to remove them after the migration is complete.

The ending size of the database doesn't bother me, I believe there are
many columns that are VARCHAR in the SQL database with a bunch of white
space.

The migration starts out writing about 300k every 5 seconds, then it
quickly goes down hill, when the database file reaches 16MB in size, the
migration is writing 300k every 70 seconds and continues to deteriorate.

I have tried setting the db cache size to 500MB, no difference in
performance.

Dan


Robert Waywell Posted on 2003-07-10 13:39:39.0Z
From: "Robert Waywell" <nospam_rwaywell@ianywhere.com>
References: <060BAD1B0CCF489C00758E9585256D5C.00758EC485256D5C@webforums> <uE#4$DWRDHA.358@forums-2-dub> <0592720AF081A486005FBA2A85256D5E.0059380385256D5D@webforums>
Subject: Re: MS SQL 7 to ASA 8 migration
Date: Thu, 10 Jul 2003 09:39:39 -0400
Lines: 64
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <OuDQcnuRDHA.349@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: rwaywell-pc.sybase.com 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1312
Article PK: 3547

Dan,
A few questions:

1) Are the MS-SQL Server and the ASA server on the same machine or different
machines?
2) Assuming different machines, is either machine stressed in terms of CPU
utilization or Disk I/O?
- if so, which process or processes is consuming the resources?
3) Assuming different machines, have you ruled out network bandwidth issues?
4) Is anyone else using the SQL Server at the time?
- could this be a concurrency issue retrieving data from the SQL Server?

The time the migration is taking doesn't make sense on either the PIII
or the Dual Xeon box. Both of these machines should complete this process
much faster.
--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

<danrhcos> wrote in message
news:0592720AF081A486005FBA2A85256D5E.0059380385256D5D@webforums...
> One more try on the response.....
>
> I am migrating using the Migration Wizard. I am connecting to the MS
SQL
> database via ODBC. I have tried the migration with the MS SQL database
on
> the same machine as well as on a different machine....no difference in
> performance. To me it appears to be an ASA issue.
>
> I believe the Migration wizard is using proxy tables since it asks me if I
> want to remove them after the migration is complete.
>
> The ending size of the database doesn't bother me, I believe there are
> many columns that are VARCHAR in the SQL database with a bunch of white
> space.
>
> The migration starts out writing about 300k every 5 seconds, then it
> quickly goes down hill, when the database file reaches 16MB in size, the
> migration is writing 300k every 70 seconds and continues to deteriorate.
>
> I have tried setting the db cache size to 500MB, no difference in
> performance.
>
> Dan


danrhcos Posted on 2003-07-10 23:13:05.0Z
From: danrhcos
Date: Thu, 10 Jul 2003 19:13:05 -0400
Newsgroups: ianywhere.public.general
Subject: Re: MS SQL 7 to ASA 8 migration
Message-ID: <17F0D2F6CF0C72CB007F8A7885256D5F.0050B38B85256D5F@webforums>
References: <060BAD1B0CCF489C00758E9585256D5C.00758EC485256D5C@webforums> <uE#4$DWRDHA.358@forums-2-dub> <0592720AF081A486005FBA2A85256D5E.0059380385256D5D@webforums> <OuDQcnuRDHA.349@forums-2-dub>
Lines: 22
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:1313
Article PK: 3548

Hi Robert,

1) I've tried running MS SQL on the same machine as well as a different
machine, no difference in performance.
2) When the migration and MS-SQL are running on the same machine, the
CPU's are 75% idle. THe majority of the processing is being done by
MS-SQL....only 1% is being consumed by ASA.
3) The migration is the only thing running on the machines...in either
configuration. The machines are dedicated to the migration and they are on
a separate network, nothing else connected.

Looks like it is potentially a bottleneck with the rate that MS-SQL is
handing out data......hmmmmm

Is there another way to export/import data? I've tried using DTS with
MS-SQL but that doesn't work due to some data type issues. I considered
creating the schema, then exporting the data from each table into a csv,
but this is very labor intensive as there are several hundred tables.

Any other ideas?

Dan


Robert Waywell Posted on 2003-07-11 10:54:59.0Z
From: "Robert Waywell" <nospam_rwaywell@ianywhere.com>
References: <060BAD1B0CCF489C00758E9585256D5C.00758EC485256D5C@webforums> <uE#4$DWRDHA.358@forums-2-dub> <0592720AF081A486005FBA2A85256D5E.0059380385256D5D@webforums> <OuDQcnuRDHA.349@forums-2-dub> <17F0D2F6CF0C72CB007F8A7885256D5F.0050B38B85256D5F@webforums>
Subject: Re: MS SQL 7 to ASA 8 migration
Date: Fri, 11 Jul 2003 06:54:59 -0400
Lines: 55
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <uIPEHw5RDHA.314@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: rwaywell-pc.sybase.com 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1316
Article PK: 3550

Does the disk I/O look saturated at all?
- I would check this through either Task Manager|Processes and monitor
the I/O Read Bytes and I/O Write Bytes or through Performance Monitor,
looking at the Physical Disk counters for Avg Disk Queue Length and Current
Disk Queue Length. If the Performance Monitor values are greater than 0,
then you are waiting on disk I/O.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

<danrhcos> wrote in message
news:17F0D2F6CF0C72CB007F8A7885256D5F.0050B38B85256D5F@webforums...
> Hi Robert,
>
> 1) I've tried running MS SQL on the same machine as well as a different
> machine, no difference in performance.
> 2) When the migration and MS-SQL are running on the same machine, the
> CPU's are 75% idle. THe majority of the processing is being done by
> MS-SQL....only 1% is being consumed by ASA.
> 3) The migration is the only thing running on the machines...in either
> configuration. The machines are dedicated to the migration and they are
on
> a separate network, nothing else connected.
>
> Looks like it is potentially a bottleneck with the rate that MS-SQL is
> handing out data......hmmmmm
>
> Is there another way to export/import data? I've tried using DTS with
> MS-SQL but that doesn't work due to some data type issues. I considered
> creating the schema, then exporting the data from each table into a csv,
> but this is very labor intensive as there are several hundred tables.
>
> Any other ideas?
>
> Dan


danrhcos Posted on 2003-07-11 14:35:57.0Z
From: danrhcos
Date: Fri, 11 Jul 2003 10:35:57 -0400
Newsgroups: ianywhere.public.general
Subject: Re: MS SQL 7 to ASA 8 migration
Message-ID: <8FDB0B094F8887FC0050321085256D60.0044401E85256D60@webforums>
References: <060BAD1B0CCF489C00758E9585256D5C.00758EC485256D5C@webforums> <uE#4$DWRDHA.358@forums-2-dub> <0592720AF081A486005FBA2A85256D5E.0059380385256D5D@webforums> <OuDQcnuRDHA.349@forums-2-dub> <17F0D2F6CF0C72CB007F8A7885256D5F.0050B38B85256D5F@webforums> <uIPEHw5RDHA.314@forums-2-dub>
Lines: 4
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:1319
Article PK: 3552

No saturation what so ever. Not only are the counters 0, the lights on
the disk only appear to blink when ASA is writing.
This particular machine has a RAID controller on it with 128MB of ram. The
disks are all 10k rpm disks.


Robert Waywell Posted on 2003-07-11 17:09:29.0Z
From: "Robert Waywell" <nospam_rwaywell@ianywhere.com>
References: <060BAD1B0CCF489C00758E9585256D5C.00758EC485256D5C@webforums> <uE#4$DWRDHA.358@forums-2-dub> <0592720AF081A486005FBA2A85256D5E.0059380385256D5D@webforums> <OuDQcnuRDHA.349@forums-2-dub> <17F0D2F6CF0C72CB007F8A7885256D5F.0050B38B85256D5F@webforums> <uIPEHw5RDHA.314@forums-2-dub> <8FDB0B094F8887FC0050321085256D60.0044401E85256D60@webforums>
Subject: Re: MS SQL 7 to ASA 8 migration
Date: Fri, 11 Jul 2003 13:09:29 -0400
Lines: 32
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <#cjmYB9RDHA.191@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: rwaywell-pc.sybase.com 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1321
Article PK: 3554

I'm getting stumped. Were you perhaps already talking to one of our System
Consultants? If so, I would like to follow this up through him.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

<danrhcos> wrote in message
news:8FDB0B094F8887FC0050321085256D60.0044401E85256D60@webforums...
> No saturation what so ever. Not only are the counters 0, the lights on
> the disk only appear to blink when ASA is writing.
> This particular machine has a RAID controller on it with 128MB of ram. The
> disks are all 10k rpm disks.


Piter Posted on 2003-07-08 15:52:12.0Z
From: "Piter" <piter@piter.pi>
References: <060BAD1B0CCF489C00758E9585256D5C.00758EC485256D5C@webforums>
Subject: Re: MS SQL 7 to ASA 8 migration
Date: Tue, 8 Jul 2003 17:52:12 +0200
Lines: 41
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
Message-ID: <OC6lPFWRDHA.186@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: vpn-uk-012.sybase.com 158.76.101.12
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1288
Article PK: 3538

There is one doc, about Migration from MS to ASE. I thing some points could
be usefull for you: http://www.sybase.com/linux/ase

Microsoft SQL Server to Sybase ASE Migration Guide
For Microsoft SQL Server developers porting their applications
to Linux, Sybase ASE is the logical platform to partner with. This
comprehensive guide describes the ease of port from Microsoft SQL Server to
Sybase ASE and outlines the process for porting an application.
Click here to download the guide.
http://crm.sybase.com/sybase/www/ESD/MSMigrationGuide.jsp

<danrhcos> wrote in message
news:060BAD1B0CCF489C00758E9585256D5C.00758EC485256D5C@webforums...
> I am trying to migrate an MS SQL 7 database to ASA 8 and am having some
> difficulty. Here is what I am experiencing.
>
> MS SQL database is approx. 3.3 GB in size
>
> My first attempt was run on a PIII 700 with 384 MB RAM. The migration
took
> about 18 hours to complete. The resulting database was 500MB in size
>
> I then switched to a Dual Xeon 2.0GHz with 1024 MB RAM. The migration
> never completed and after about 25 hours was only about one-third of the
> way done. This doesn't make any sense to me since it appears that the
> migration is CPU intenisve, so it should just fly......
>
> All of my hardware has all of the latest updates, all of my software has
> all of the latest updates. I have run all of the diagnostic/performance
> tests on the hardware and it appears to be just fine.
>
> Here are my questions:
> 1) any idea how long this migration should take?
> 2) any idea why it is dog slow on a dual Xeon machine?
> 3) is it normal to turn a 3.3GB database into 500MB ?
>
> Any help would be appreciated.