# postgresql and sqlserver

**URL:** <https://forum.servoy.com/t/postgresql-and-sqlserver/15501>\
**Category:** Classic Servoy\
**Created:** [February 14, 2012, 1:27am UTC](https://forum.servoy.com/t/postgresql-and-sqlserver/15501 "2012-02-14T01:27:26Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![pogie.nocedo](https://avatars.discourse-cdn.com/v4/letter/p/e79b87/32.png) [@pogie.nocedo](https://forum.servoy.com/u/pogie.nocedo)\
**Post date:** [February 14, 2012, 1:27am UTC](https://forum.servoy.com/t/postgresql-and-sqlserver/15501/1 "2012-02-14T01:27:26Z")

</div>

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.

```auto
"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

---

<div class="post-metadata">

**Author:** ![Mark\_Crichton](https://avatars.discourse-cdn.com/v4/letter/m/3ab097/32.png) [@Mark\_Crichton](https://forum.servoy.com/u/Mark_Crichton)\
**Post date:** [February 24, 2012, 9:01am UTC](https://forum.servoy.com/t/postgresql-and-sqlserver/15501/2 "2012-02-24T09:01:35Z")

</div>

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](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