Results 1 to 5 of 5

Thread: SQL Server 7 to 2000 w/NTEXT

  1. #1
    Join Date
    Jan 2010
    Posts
    2

    Question SQL Server 7 to 2000 w/NTEXT

    I am trying to migrate our SQL Server 7 databases (140+ databases) to SQL Server 2000. I have all the databases setup and their login accounts. I can backup from the old machine and restore to the new machine fine, but the problem I am having is that none of the "long text" ntext information is coming across.

    The one fly in the ointment is that with the old system, I am REALLY trying to avoid having to take the database offline as a lot of our clients are using it. If it absolutely comes to it, a late night shut down could be done.

    Is there something I should be doing though to get the long ntext information to come across or somewhere I can copy/backup and restore?

    Help would be much appreciated.

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Backup and restore should bring all the data. Are the ntext columns blank?. You can try restoring to SQL 7 itself and see if it is appearing there. If it is there, then you can detach new database, copy files and attach to SQL 2K to see if detach/attach works.

  3. #3
    Join Date
    Jan 2010
    Posts
    2
    Thank you!

    Your reply actually got me to trying to pull data out of the table to ensure that there was nothing in those "blank" fields. And although, they show as blank on the actual server - if I use asp to display the information, the information is there. I don't quite understand why I don't see a "<long text>" in the field like before, but I am glad the information is there.

    Thank you once again.

    Cheers!

  4. #4
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can use SUBSTR in SELECT to select first few characters to verify if there is anything.

  5. #5
    Join Date
    Sep 2002
    Posts
    5,938
    Sounds you have to test your app against sql2k first before upgrading.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •