Get Data Moving 1
Results 1 to 2 of 2

Thread: My Source Database table are Case Sensitive

  1. #1
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    297
    Rep Power
    6

    My Source Database table are Case Sensitive

    My Source Database table are Case Sensitive, Replicate run Full Load with success, however CDC error on:

    Table ,,,, doesn't exist [122502] ODBC general error.

    Note that my target Database is Redshift.

  2. #2
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    297
    Rep Power
    6
    Quote Originally Posted by stevenguyen View Post
    My Source Database table are Case Sensitive, Replicate run Full Load with success, however CDC error on:

    Table ,,,, doesn't exist [122502] ODBC general error.

    Note that my target Database is Redshift.
    Since Redshift does not support Case Sensitive Table name, we need to use Global Transformation to change the table name to lower case.

    Name:  table lower case.jpg
Views: 273
Size:  82.3 KB

Posting Permissions

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