sqlserver2pgsql
sqlserver2pgsql copied to clipboard
dalibo
Migration tool to convert a Microsoft SQL Server Database into a PostgreSQL database, as automatically as possible
Hello, maybe a question is not about sqlserver2pg but on pentaho git page issues is not available. So question is, PDI is working? I was trying many ways for install...
Hi Team, The current behaviour of the tool is that it errors out during schema conversion if it finds some unknown clause. Example ``` Cannot determine the PostgreSQL's datatype corresponding...
Please give me the detailed information for the question
In some MSSQL views I have `WITH (NOLOCK)` statements after the table names. E.g. the SELECTs look something like this: ```sql SELECT * FROM mytable WITH (NOLOCK) ``` Such `WITH`...
Attempting to migrate an ArcGIS database from MSSQL to PGSQL. Created the SQL dump, configured a conf file for the conversion script with all default behaviors. I did configure connection...
Hello, While using your tool (pretty great btw), problems with triggers occurred : ``` Warning: Trigger dbo].[OnDelRun ignored Line (2530) not understood. This is a bug at sqlserver2pgsql.pl line 2551,...
Hi, Not sure this is the right place to report issues faced while using sqlserver2pgsql.pl in command prompt. Passed a input file with create statement and got the below error...
Hi, while running this on Windows I am getting the following error: Encodings too ambiguous: utf8 or iso-8859-15 at ./sqlserver2pgsql.pl line 1506. How can it be fixed
Hi Team, If we have a date time type column with a default value ex: ``` ALTER TABLE [dbo].[AAFILE] ADD CONSTRAINT [DF_AAFILE_created_on] DEFAULT (sysdatetime()) FOR [created_on] ``` The function **sysdatetime()**...
While migrating the table data thru kettle tool from sql server to postgresql database getting below- **2023/03/15 16:59:52 - write to [REPORTS].0 - Caused by: org.postgresql.util.PSQLException: ERROR: column "NAME" of...
