Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ashrefcp
Starting Member
7 Posts |
 Posted - 2008-01-20 : 06:55:05
|
| I would like to use bcp and transfer image data from MS-SQL Server 6.5 to MS SQL Server 2005.1. Can I use bcp successfully? if so should I mention any option to copy the BLOB?2. Is there any reliable method to move tables with BLOBsRegards,/ash |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-01-20 : 14:11:15
|
| First of all, you have to transfer to SQL server 7.0 or SQL server 200 |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-20 : 20:11:11
|
| Then you can move it with data import wizard. |
|
|
|
ashrefcp
Starting Member
7 Posts |
Posted - 2008-01-20 : 23:48:33
|
Can I do dump and load to MS-SQL 7 from 6.5? The import will need exclusive access to the source I believe - which is difficult in our case./ashquote:
Originally posted by rmiao
Then you can move it with data import wizard.
|
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-01-21 : 00:06:41
|
| Database backups that were created by using SQL Server 6.5 or earlier are in an incompatible format and cannot be restored in SQL Server 2005. Migrate data from a SQL Server 6.0 or SQL Server 6.5 database by using bcp out to export the data into a data file in character mode Then, use bcp in with the -V option to import the data into a SQL Server 2005 databasecheck this out: http://msdn2.microsoft.com/en-us/library/ms191212.aspx |
|
|
|
ashrefcp
Starting Member
7 Posts |
Posted - 2008-01-21 : 06:04:18
|
Hi,This was my original question. Will bcp takecare of the image data properly. In sybase, there is an option -T to bcp out the text/image data./ashquote:
Originally posted by sodeep
Database backups that were created by using SQL Server 6.5 or earlier are in an incompatible format and cannot be restored in SQL Server 2005. Migrate data from a SQL Server 6.0 or SQL Server 6.5 database by using bcp out to export the data into a data file in character mode Then, use bcp in with the -V option to import the data into a SQL Server 2005 databasecheck this out: http://msdn2.microsoft.com/en-us/library/ms191212.aspx
|
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-01-21 : 09:53:41
|
| Please See the link i have sent you. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-21 : 15:49:39
|
| Works with text column but not sure about image column, you can test it easily. |
|
|
|
|
|
|
image data from MSSQL 6.5