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 |
|
sholana
Starting Member
4 Posts |
 Posted - 2002-11-11 : 10:55:34
|
| I have to move a DB from 6.5 to 7.0.Two problems :1) the machines cannot see each other so i tried a backup of the 6.5 and restore in the 7.0 the data was incompatable.2) Going to try a table by table install DTS export and import. however I hav image and text data in atleast one table will this cause a problem? If so how Do I over come this? |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-11-11 : 11:44:43
|
| One way to overcome this would be to install 6.5 on the destination server, restore the backup, and then do an in place upgrade to 7.0. If you go with a table import/export, I think you should be OK with the text and image data as long as you BCP the data out in native format.Jeff BanschbachConsultant, MCDBA |
 |
|
|
sholana
Starting Member
4 Posts |
Posted - 2002-11-11 : 12:08:08
|
Thanks!  |
|
|
|
|
|
|
sql 6.5 to 7.0