--- Jonathon Stierman <jonathon@vimm.com> wrote:
> Yep, it definitely is a SQL dump -- it looks much the same as .sql files
> that I'm used to dealing with on MYSQL databases.
>
> Do you have any favorite translator tools that I could look in to? The file
> is massive (58 megs worth) and going through it by hand would be quite
> tedious.
I bet most of the 58MB are just data. If you can, see if you get get another dump of only the db
SCHEMA. This is what you should take a look at first. I would look at the datatype and any
constraints and compare what the other DB support.
If you only care about the tables and data, you could also "suck" these tables into MS-Access
using ODBC. Next you could rebuild the relationship that existed in PostgreSQL. From this point
I see that MS SQL server has help docs on how to port MS-Access to MS-SQL Server.
Regards,
Richard Broersma Jr.