Member Avatar for faizurrahman

Urgent help Please!
I have a table exist in two database on two different 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

  • 2 Contributors
  • 1 Reply
  • 59 Views
  • 20 Hours Discussion Span
  • Latest Post Latest Post by Ramy Mahrous
Member Avatar for Ramy Mahrous

What's the error?
You can use Import\Export data. (right click on the database->All tasks-> Import\Export data)

I guess the error because there's violation in primary key... you've to provide us with the error.

If the two tables (has difference in structure columns number, different datatypes) I recommend you to use SQL Server Integration Services.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.