dbTalk Databases Forums  

sa_migrate create index problem (more than 8 index per table)

sybase.public.sqlanywhere.mobilink sybase.public.sqlanywhere.mobilink


Discuss sa_migrate create index problem (more than 8 index per table) in the sybase.public.sqlanywhere.mobilink forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Timrek
 
Posts: n/a

Default sa_migrate create index problem (more than 8 index per table) - 02-27-2006 , 02:02 PM






Is anybody have problem creating index while migrating a
consolidated database to a ASA database. I'm having problems
: with tables having more than 8 index. Under 6 index per
table seems to work fine. The procedure sa_migrate seems to
have problem with more than 8 index/table.

Reply With Quote
  #2  
Old   
Breck Carter
 
Posts: n/a

Default Re: sa_migrate create index problem (more than 8 index per table) - 02-27-2006 , 03:06 PM






What version of ASA?

What kind of database is being migrated?

What exactly is the symptom or error message?

Breck

On 27 Feb 2006 12:02:48 -0800, Timrek wrote:

Quote:
Is anybody have problem creating index while migrating a
consolidated database to a ASA database. I'm having problems
: with tables having more than 8 index. Under 6 index per
table seems to work fine. The procedure sa_migrate seems to
have problem with more than 8 index/table.
--
breck.carter (AT) risingroad (DOT) com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhe...ers_Guide.html


Reply With Quote
  #3  
Old   
David Fishburn
 
Posts: n/a

Default Re: sa_migrate create index problem (more than 8 index per table) - 02-27-2006 , 10:08 PM



Timrek wrote in news:44034b74.5dc7.1681692777 (AT) sybase (DOT) com
of sybase.public.sqlanywhere.mobilink:

T> Is anybody have problem creating index while migrating a
T> consolidated database to a ASA database. I'm having problems
T>: with tables having more than 8 index. Under 6 index per
T> table seems to work fine. The procedure sa_migrate seems to
T> have problem with more than 8 index/table.

As Breck pointed out:
Please ALWAYS include version and MORE importantly BUILD number
with EACH post (dbeng9 -v).

Also show us:
1. The create table statement
2. Schema for the 8 indicies
3. What source the database is (ie Oracle and version info).

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase....ctDocumentList


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.