• You still need some manual works in my suggestion.

    1. Backup database and rename it.

    2. Generate scripts for all database objects.

    3. Replace varchar with nvarchar in the scripts.

    4. Create new database as you need.

    5. Run above scripts to create objects.

    6. DTS/Import data from old database.