We're using MS SQL Server 2005 at work and I want to export our data to PostgreSQL for testing.
MS SQL Server has an export function but the only one that looks like it would work would be to export to Excel files. I'd rather use a SQL script or function that can export to a file and import those files into a PostgreSQL server for testing. I've searched a number of sites for a SQL script but I can't find one that will work.
What would be a good approach to accomplish this?