21 апреля 2012 г. 20:32
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
22 апреля 2012 г. 15:36Модератор
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.
16 мая 2012 г. 8:18
Hope this may help you, please check it.