Migrating image data from one database schema to another
Quote:
> Is anyone familiar with migrating image or text data from one database
> schema to another. Specifically is it possible to use transact sql to
> select a column of image data and place it in another table? I have to
> assume that the data in the image column could be as large as the
> maximum size of 2 GB (correct me if the max size is more or less). If I
> cannot use TSQL to migrate the data would it be best to use sybperl with
> calls to DB lib or CT lib? Is there a simple way to move image data
> from one table to the next that anyone is familiar with? Is it possible
> to use bulk copy to move the data? Any information would be appreciated.
Any of the methods you've highlighted should work. If the copy
is just within the same server (which you seem to imply), I'd
just go with the select/insert method. Its the fastest and
easiest. Just check that the variable that limits the size of
text and image data is set correctly (it should already be if
you already have data stored up to the maximum size allowed).
-am
