Post reply

Exporting SQL Server data to SQL Anywhere

  • January 17, 2007 at 6:51 pm

    #92169

    Hi,

    I need to export a full demo database from SQL Server to Adpative Server Anywhere (SQL Anywhere). I do this using the export data wizard and all the data seems to get there. All record counts are correct and when i "select * from table" the correct data appears 

    My problem is that whenever i run a query such as "select *from table where saletype = 'ANA' " it returns no rows even though i can see the data is there!

    Any ideas anyone ?

    Thanks

     

  • January 22, 2007 at 11:04 am

    #684752

    there's a few things you should check:

    first off, does "select *from table " return any rows? here we determine that data exists.

    second, could it be that the db is case sensitive? so " where saletype = 'ANA' " cant find 'ana'

    third, check for null values and see what happens?

    "select *from table where  saletype  is not null AND  saletype = 'ANA' "

     

    hopefully some of these ideas might help you get started on finding out why you don't get the expected data.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • January 22, 2007 at 7:14 pm

    #684836

    Thanks for that Lowell, it did steer me in the right direction when you started talking about nulls.

    I tried a like 'ANA%' instead of an equal and it returned data as the SQL Anywhere was padding the values with blanks.

    Am trying a few SQL Anywhere database create options now to get round this.

    Cheers!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply