Import data from PostgreSQL to MS SQL Server

• itlk

  Mr or Mrs. 500

  Points: 578

  More actions

  July 7, 2021 at 10:10 pm

  #3905520

  I am trying to import data from the PostgreSQL into the MS SQL Server database, using SQL Server Import and Export Wizard. During the column mapping I get the following error:

  The column attribute "COLUMN_SIZE" is not valid.

  The column attribute "DECIMAL_DIGITS" is not valid.

  The column attribute "COLUMN_SIZE" is not valid.

  I modified the ProviderDescriptors.xml file, and changed the MaximumLengthColumnName, NumericPrecisionColumnName to COLUMN_SIZE  and DECIMAL_DIGITS.

  I am using .NET Framework Data Provider for MS SQL Server driver. However, ProviderDescriptors.xml contains entries only for: "System.Data.OleDb.OleDbConnection", "System.Data.SqlClient.SqlConnection", "System.Data.OracleClient.OracleConnection", "System.Data.Odbc.OdbcConnection", "Microsoft.HostIntegration.MsDb2Client.MsDb2Connection". To be sure I changed the property in all places where available, but it didn't help.

  What am I doing wrong?

  • This topic was modified 3 years, 4 months ago by  itlk.

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  July 8, 2021 at 11:10 pm

  #3905916

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.