I am currently moving several databases from MSSQL 2008 and IBM DB2 9.7 to PostgreSQL 9.0.3 using a commercial tool named ESF Database Migration Toolkit. This tool allows us to migrate any database from a DBMS to another in just a few clicks. It works really well and accelerates the migration process a lot.
The problem I have only occurs when migrating from MSSQL 2008 to PostgreSQL. All accents within the database are not getting transfered properly. For instance : "StÚphane" instead of "Stéphane".
It looks like a collation/locale problem, but I can't figure out what's wrong in my databases configurations.
MSSQL 2008 database information (source database)
collation : SQL_Latin1_General_CP850_CI_AI
MSSQL 2008 OS information (Windows 2008 Server R2)
Locale : English (Canada)
Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software.
Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers.
Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…