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.