Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006
    Posts
    5

    Unanswered: bcp out/in and different schemas

    Hi ,
    I am researching BCP in/out. on tables.

    What solutions solutions has Sybase to allow for different table schemas ?

  2. #2
    Join Date
    Jan 2003
    Location
    Geneva, Switzerland
    Posts
    353
    If you mean different table structures then you should take a look at bcp format files. They are described in the Utility manual.

    If you mean schemas in the Oracle sense then you specify the target as part of the table name (database.owner.table).

    Michael

  3. #3
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    If the source and target and different table schema's then you need to create a view on top of the source with a schema that matches the target using implicit or explicit conversion and then bcp out of the view.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •