I have some data that is from a Postgres database dump (not csv or anything) and I am looking to get it into MS SQL. Is there an easy way to do this or a free tool that doesn't have limits on data import size etc?
The Postgres is on a Debian VM and I could export it to csv in there but I am new to Linux and don't know how I would transfer it from the VM to Win 7.
Thanks
Best Answer
On SQL Server you could use SSIS to parse the CSV files and load them into tables. If they are in the proper format to start with, you can use bulk import on the sql server side for fast load from a script.
That is about the best 2 says I can easily see ;)