in powershell what's a good way to move data from db A to db B ?

Hello,

I need to move data from DB A to  DB B  with powershell. the db server is sqlserver.

i'm moving data from table to table, only columns names are different and in a different order.

what would be a good way to do this ?

thank you in advance for your help.

toshi
Erwin PombettAsked:
Who is Participating?
 
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
You can't do that with SQL on the SQL Server machine directly?

You should perform that via a client only if you do not have connections between both DBs on the server(s). And you'll have to copy row by row that way.
0
 
Erwin PombettAuthor Commented:
Hello Qlemo,

thank you for your reply,

actually both server can not communicate with each other.
0
 
Erwin PombettAuthor Commented:
thank Qlemo,

indeed it was the way to do it.
thank you

toshi
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.