Postgres to Microsoft

[Anon]

If i have a postgres database using the serial datatype can i import it to a microsoft sql server database?

I'm asking because as far as i know postgres is the only dbms that uses the serial datatype. Correct me if I'm wrong, please 🙂

Thanks

[kparker]

Sure you can. 'Serial' is actually just a shorthand for (1) creating a sequence, (2) creating a column of type int4, and (3) using nextval(sequence) as the default value for the column.