<div>
FYI the MY SQL database is not on site - we are connecting to it using an OBDC (other) connection.
</div>


FYI the MY SQL database is not on site - we are connecting to it using an OBDC (other) connection.

<div>
Just to clarity database 1 is a MS SQL Server 2000 and database 2 is my SQL (4.1.7)<br />
<br />
<br />
we are using DTS to tranfer a table from database 1 to database 2
</div>


Just to clarity database 1 is a MS SQL Server 2000 and database 2 is my SQL (4.1.7)


we are using DTS to tranfer a table from database 1 to database 2

<div>
Thanks for the help - <br />
we got it done by transfering the table to access and then exporting it to the mysql database 
</div>


Thanks for the help -
we got it done by transfering the table to access and then exporting it to the mysql database

<div>
<div class="content wysiwyg-content">
Hello<br />
<br />
I have a SQL Server here and I am copying a table from it to a MS SQL database using DTS. One of the fields in the table is a medium text (entries in it are about 300 characters.) DTS will not allow me to move a BLob so I have to split the data up into 2 fields and they concatenate them - any suggestions do I don't have to do this?<br />
<br />
Thanks <br />
jculkincys
</div>
</div>


Hello

I have a SQL Server here and I am copying a table from it to a MS SQL database using DTS. One of the fields in the table is a medium text (entries in it are about 300 characters.) DTS will not allow me to move a BLob so I have to split the data up into 2 fields and they concatenate them - any suggestions do I don't have to do this?

Thanks 
jculkincys

Transfering a Blob between SQL Server 2000 and MY SQL using DTS

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.