Migrating code from SQL Server to Redshift.
64 bit Powershell script.
This is the SQL Server table:
CREATE TABLE dbo.psql_test
(
id INTEGER NOT NULL,
varchar_255 VARCHAR(255),
date_dt DATETIME,
varchar_10 VARCHAR(10),
timestamp_dt DATETIME2
);
This is the Redshift table
CREATE TABLE mocsdw.psql_test
(
id INTEGER,
varchar_255 VARCHAR(255),
date_dt DATE,
varchar_10 VARCHAR(10),
timestamp_dt TIMESTAMP
)
DISTSTYLE EVEN;
Attachments - old working code for MS SQL LoadMSOLEDB.ps1
new code for Redshift LoadOLEDB.ps1
Old code insert new row into table.
New code insert empty row into table
Thank you,
Dmitriy Burtsev
