December 13, 2012 at 10:40 am
Hi I have a table in a database which is in 2008 SQl. I want to export that table to another server which is SQL 2005.
Table contain two columns which have image data type(image encrypted ). I tried import export wizard and realized it cannot be used due to data type issue. I cannot restore source database on destination server as it does not support backward compatibility. Can any one help.
December 13, 2012 at 10:52 am
The image datatype exists for 2005. Use the import data wizard on the 2005 instance and you should be fine. Of course you said you are using the image datatype. That has been deprecated, instead you should use varbinary(max).
http://msdn.microsoft.com/en-us/library/ms187993.aspx
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
December 13, 2012 at 11:19 am
Thanks for reply
Actually in the source table there are 2 coloumns which store image data. So you say me to use import export wizard and use varbinary(max) for those 2 columns. I fear of getting false data if we use so. any way I Will try that.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply