Table Date Migration

[faizurrahman]

Urgent help Please! I have a table exist in two database on two different server in sql server. I want to get the data of table from one table and another. When I am using OPENROWSET command it through error. I don't know what it mean. Is there any way to migrate the data. One problem is that I have a column for multi language when i migrate the date the multilingual colum show ??????? and not the original one. thanks in advance

[Wendelius]

It would greatly help if you post the command you tried to use and the error message you got.

The need to optimize rises from a bad design.My articles[^]