Transferring Columns of datatype sql_variant is not supported .

Question

Hello,

I am trying to copy a database using transfer object using smo.transfer object.I have set all the desired properties of transfer object to true.I have a table in a database with column having datatype sql_variant.When I call transfer.TransferData method it throws an exception"Transferring Columns of datatype sql_variant is not supported ."All  table schemas are copied and the datas of only those tables are copied until it encounters that particular table with column datatype sql_variant and does not transfer data further.

Kindly suggest the solution or the cause of problem.It will be a great help.

It is urgent

Thanks

Answer 1

Hello,

Please, could you provide the version of your Smo.Transfer object ( 2005,2008,2008 R2,2012)? It is an information which could be be useful.

Please, also, could you provide the version of the source database and the version of the destination database ( CompatibilityLevel of each database ) ?

Please, could you provide your code ? It would be easier to understand your problem.

Please, also, could you provide the definition of your table ?

We are waiting for your feedback to try to help you more efficiently.

Have a nice day

PS : Have you looked at http://msdn.microsoft.com/en-us/library/ms173829.aspx  and especially the part Converting sql_variant Data?

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

Answer 2

Hope this may help you, please check it.

http://www.sqlteam.com/article/the-sql_variant-datatype