Migrating image data from one database schema to another 
Author Message
 Migrating image data from one database schema to another

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.
Thank you



Tue, 11 Apr 2000 03:00:00 GMT
 Migrating image data from one database schema to another

bcp will work with text data and you have to specify the maximum size
of the test data with an option to the bcp program



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.
> Thank you



Wed, 12 Apr 2000 03:00:00 GMT
 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



Thu, 13 Apr 2000 02:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Migrating Data from one database to anouther

2. migrating MS SQL Server database schema to Oracle 9i

3. how to copy one schema from another schema

4. Copying schema objects from one user's schema to anothers

5. Migrating BLOB data from one instance to another

6. Moving All object from one schema to another schema in Oracle

7. Copy table schema and data from one DB to another DB

8. Migrating OLAP Databases from one Server to another

9. SP or tool for creation of one schema script of one table without MS SQL EM

10. Migrating database from one domain to another

11. linking Tables from one database Schema To another

12. Transfer Database Schema from one SQL Server to another


 
Powered by phpBB® Forum Software