postgresql and sqlserver

Classic Servoy
1

hi!
i tried to disconnect to my postgresql database and connect to an sqlserver database and create the tables using servoy developer but after the tables were created, there were problems in the dbi file particularly in the data type “text”, and “numeric” columns.

"xxx->policy->notes" column difference. (TEXT(id:12), length: 2147483647, allowNull: true) in DB <-> (TEXT(id:2005), length: 1073741823, allowNull: true) in DB information file. The DB information on this column differs from the actual column in the DB.	policy.dbi	/resources/datasources/xxx	JSON file	Database information inconsistency
"xxx->product->amount" column difference. (NUMBER(id:2), length: 19, allowNull: true) in DB <-> (NUMBER(id:2), length: 131089, allowNull: true) in DB information file. The DB information on this column differs from the actual column in the DB.	product.dbi	/resources/datasources/xxx	JSON file	Database information inconsistency

What are the possible side-effects?

Thanks and Regards,
Rogel

2

HI Pogie

I have used DBConvert to convert my FoxPro to MySql and they were very helpful when I had a problem and fixed the program.

I think I used NAVICAT to convert between MySql to PostgreSQL databases. I suggest look at
http://www.navicat.com and use the trial version to do a test conversion to see if you get more exact field type matches.

Good luck

Mark