Importing xml file to table in sql serverHi,
I have a database and contains a table that has varbinary column.
I am inserting filetype .repx into it. It works fine.
Then I am exporting the table data to xml.
I need to import this xml data to same table in a different database.
but I am getting issues with import.
When I got it imported, the file is not opening .
It has got binary data starting with 0x2 in the first database.
In the second database, it is starting with 0x4.
Please help. Its urgent,
How to import in right format ?