pgsql to sqlserver

[Anon]

Hi here,

I've to migrate a postgresql database into sqlserver, but my database contains a lot of datetime fields wich contains datas like "Tue 20 Nov 18:17:36 2001 CET"

after having do a dump -n -d database , I get the good sql request but sqlserver hate my timestamps.
How can I convert them into a valid datetime format for sqlserver?

my database is really heavy, so I can't do this one per one.

10x a lot

[Anon]

Hi,

Try: http://techdocs.postgresql.org/ for lots of information on changing database backends to and from PostgreSQL.

Off the top of my head, the only thing I can think of to do is to run a sed script over the dump to reformat all the timestamps for you.

Chris

[Anon]

yes, I think it's the better way.
I'll try to make a php script wich will extracts the datas and create the dump file.