[linroc]

I should probably one time create the sql (based on the corrected wizard sql) and save it to use in the future.

Well it seems i have my data for this time and the weekend is closing in 😀 . I must try the optimization next time (which is next month i think).

Thanks for your replies – as always very helpfull.

/cartmann

peterlaursen wrote on Feb 3 2006, 03:25 PM:

well, then override the proposal of that silly ODBC-driver!  Simply press the 'map' button in the Migration Wizard for the column(s) and change the name and type as you like (as long as it is legal with the data). 

In this respect that you can override the driver, the SQLyog Migration Tool is unique!

[post=”8650″]<{POST_SNAPBACK}>[/post]

[linroc]

Hi,

thanks for the reply 🙂

Regarding the decimal issue – i would prefer to use doubles, but using the import wizard it chooses to use decimal. If importing with access the choice is number – which i believe is similar to the decimal – but here scale and precision are correctly.

Is there somewhere to setup the precision and scale without doing it for each field to import – I mean something like a general preference ?? Or even worse turn all fields into text fields :huh: I know big mistake – but all my work with this is ending up in text files as a customer requirement.

The speed issue – it seems it is something I need to dig into. My mysql installation is a default 4.1 windows installment – so there is probably lots of improvement possibillities.

/cartmann

[linroc]

Hi Ritesh,

sorry for not replying – but I thought this thread was ended – and I haven't received any mails about new messages (probably my own fault – haven't configured much on my profile.

I can't tell you much though. The db which caused the problems is an old Sybase version I haven't acces to it anymore.

I am using same version as you are testing with (12.5.2) – but I really think the issue is on the db side.

Sorry I can't help you more – but I am working on these customer tables on a nonregular basis as a freelance consultant (usually a 1 shoot visit to retrive data for conversion) so I haven't got acces to them.

Thanks for Your efforts

/Claus

Ritesh wrote on Sep 22 2005, 03:58 PM:

We just installed the trial version of Sybase 12.5.2 but we are unable to reproduce the error.  🙁

Can you tell me steps to reproduce the same configuration at our end? How do we create a user with permissions similar to your setup?

Also which Sybase ODBC Driver are you using?

[post=”7272″]<{POST_SNAPBACK}>[/post]

[linroc]

Hi Ritesh,

I've found it 😀

Maybe I am just a little slow 😕 – but in one of the first menu'es in the import wizard one can choose to make your own select.

So i simply uses a select like:

“select * from user1.CARD_FILE”

completes the rest of the wizard and bingo 😀

So thanks for your efforts I am on the way

best regards

Claus

[linroc]

Hi Ritesh,

now I am at the customer. Import through access using exact same odbc works fine – but here I also see the tables with the owner dotted infront

example

test.cardfile

user1.cardfile

I have attached an image of the error I receive – it seems to me that the owner should be inserted somewhere.

[attachment=243:attachment]

Is it possible somehow to edit the sql send by the import wizard??

All hints would be appreciated 🙂

Best regards

Claus

[linroc]

Ritesh wrote on Sep 15 2005, 07:58 PM:

Can we get temporary access to the Sybase database?

[post=”7182″]<{POST_SNAPBACK}>[/post]

Tommorow i will be able to get access to a customer db – so i will try with other clients (it might be a odbc driver problem as you are suggesting)

It is impossible to give you access to these db's – sorry.

I will send more info tommorow when i have db access.

/cartmann

[linroc]

Ritesh wrote on Sep 2 2005, 08:39 PM:

Which version of Sybase are you using?

Could you provide me a link to some kind of trial download for this version of Sybase. I need to set up your environment out here.

[post=”7077″]<{POST_SNAPBACK}>[/post]

Hi,

sorry for the late reply – but I went on holiday in Tyrkey 😀

I am pretty sure it's an old Sybase System 11.

I have no knowledge of trial versions of this db (I am extracting data for some customers on their old Unix systems). So i can't even check anything before next time I am at an customer.

I can see that this won't be easy to follow up on – but i am hoping for the best 😕

/cartmann

[linroc]

peterlaursen wrote on Sep 1 2005, 10:09 PM:

What (the hell) do you want that astronomic .csv-file for?

If you want to transfer data to another database consider other possibilities such as OBDC-import.  Life is too short for CSV.  There must be other options ?!

[post=”7058″]<{POST_SNAPBACK}>[/post]

Agree – but my client prefers csv – and pays for it 😀

Actually i extract data from a sybase directly to mysql by sqlyog odbc – and then uses sqlyog to create the (f……) csv files – but it works and my client is happy 🙄

-Claus

PS: Per Laursen sounds danish ??

[linroc]

peterlaursen wrote on Sep 1 2005, 09:39 PM:

I can generate this output

etc

from the data and the export settings below.

Now a search for '^N' and replace with '' in a texteditor, and you got what you want.

If the escape character is not used I get

etc.

But  I think it is more safe to replace '^N' than 'NULL'.  Or any other crazy escape character instead of '^' that is safe to use with your data .  I just tested with '|' as well and that functions the same.

[post=”7055″]<{POST_SNAPBACK}>[/post]

Thanks for the reply – I was hoping to avoid the text replacement – but has decided to live with it 🙂 It's a bit troublesome when having 1mill+ records 🙂

/claus

[linroc]

Ritesh wrote on Sep 1 2005, 06:47 PM:

You will need to export it in FIXED LENGTH format.

[post=”7053″]<{POST_SNAPBACK}>[/post]

Thanks for the reply, but how can i combine fixed length and a ~ delimiter (seems like opposites 🙁 )

/Claus

[Author]

Posts