Forum Discussion
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
Community 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
Post 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.