Forum Discussion

Analitika's avatar
Analitika
Icon for Post Prodigy rankPost Prodigy
6 years ago

Sybase -> Postgre migrating

I have same model into two databases Sybase and Postgre.

I need change Sybase pbix template to  Postgre database, then i do that i got errors.

problems is all mesuares and columns in Sybase are Ucased but in Postgre all is Lcased.

Tryed export DataModelSchema json and replcase all Ucase to Lcase, but on import i got error

Error Message:
Cannot de-serialize Database. The JSON input is not properly formed. Check path '', line 0, position 0.

 

 

How to migrate without case sensitivity?

2 Replies

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion

    have you succesfully imported the data in without changing to upper case?  your message really isn't clear, please provide examples of what you are trying to say, and show what you are trying to do.

    • Analitika's avatar
      Analitika
      Icon for Post Prodigy rankPost Prodigy

      in Queries i change all field manually to lowercase and database connect correctly, but since all reliationships and measures and columns names in old model used UCase i cant apply changes to models, applying rotating about 30 min and then i got error from PBI.