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.