I have a rather large database (2 GB of data, 25 million rows in the largest table) on a shared web hosting. The database engine is Microsoft SQL Server 2008.
Due to high fees for the SQL Server web hosting, I would like to migrate my data from SQL Server to a Postgres database.
In my SQL Server database I have tables, indexes, constraints and stored procedures. The data types in my tables are VARCHAR
, TINYINT
, SMALLINT
, INT
, SMALLDATETIME
, REAL
and FLOAT
.
In my stored procedures I am using some built-in T-SQL Date/Time manipulation functions like DateAdd()
or DatePart()
.
Is there any FREE tool available that would help me migrate my data (tables, constraints, and if possible also the stored procedures) from SQL Server to Postgres?