exporting data from one table to another in different database using DOS command

Question

I have to transfer data from old database to new database where table name and column name is different. Can it be done with DOS command or any other solution? One is POSTGRESQL and old is MYSQL.

My concern is table name and column names are different, column number is same. Thank you

Ozgur · Accepted Answer · 2012-10-18 16:14:37Z

1

I do not know the postgresql part but for sql server you can use sqlcmd.exe to export data as text format with or w/o column names

Please check

http://msdn.microsoft.com/en-us/library/ms162773.aspx

answered Oct 18, 2012 at 16:14

Ozgur

3683 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

exporting data from one table to another in different database using DOS command

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related