[EnterpriseDB Logo] Postgres Plus Forums
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page 
MS-SQL to Advanced Server  XML
Forum Index » Tuning and Migration Wizard
Author Message
Pete_Halsted

New member

Joined: 20/01/2010 11:50:47
Messages: 1
Offline

We are working on migrating from MS-SQL to Postgres Advanced. We are using the Migration studio to attempt to convert the Schema and data. Schema is coming over but we have several tables that are giving us encoding errors (see below). We can't figure out the right combination of setting to resolve the issue.

The other issue we have is with the delimiter character we have a few tables that contain | characters. In fact all 127 of the Basic ASC chart are represented in our data, and my first attempt at using extended ascii characters above 127 didn't seem to work either. Any suggestions on what character to use?

Thanks
Pete Halsted
JK Harris
636-432-9339


First error:
Loading Table: prospect ...
Error Loading Data into Table: outboundcustomer: ERROR: invalid byte sequence for encoding "UTF8": 0xd13f
Hint: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".
Where: COPY outboundcustomer, line 865

Then when it completes all tables in first pass we get:
Trying to reload table: outboundcustomer through bulk inserts with a batch size of 1000
ERROR: character 0xefbfbd of encoding "UTF8" has no equivalent in "WIN1252", Skipping Batch
 
Forum Index » Tuning and Migration Wizard
Go to:   
Powered by JForum 2.1.8 © JForum Team