Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
6 years ago

PBI migrating

I want migrate from Sybase to Postgre, i need same data model and structure

I change successful sybase to postgre in Source on Transform Data Query editor.

But i cant aplly changes, as Postgre tables has headers name lowercased, but sybase headers was uppercased.

Also i can delete all relationships, and they do not updaiting when i press on apply.

Just got error while applying.

So question is:

  1. How to ignore headers case sensitivity?
  2. How to refresh old relations after changing source?
  3. How to bulk delete all relations?
  4. How to bulk change all columns headers?
  5. How to normally migrate from sybase to postgre?

2 Replies

  • Analitika , Open Data Transformation and right-click on a table and open Advance editor and change the details there.

    • Analitika's avatar
      Analitika
      Post Prodigy

      And? Nowhere where i can change any columns name