How to enable verbose logging in Migrator for NDS, also known as debug logging.
1. Use SQL Enterprise Manager to open the NDSMigrator database.
2. Expand the database and tables.
3. In the right window right click the t_Project table "Open Table\Return all rows".
4. This will have to be set for each project file.
5. Find the project file you want to set to verbose.
6. Scroll to the right until you find the Column "LogVerbosityLevel" set the value to 5.
Alternatively:
Run this command in the SQL\Binn folder. I.E C:\Program Files\Microsoft SQL Server\80\Tools\binn
osql -E -Q "Use NDSMigrator UPDATE T_PROJECT SET LogVerbosityLevel = '5' WHERE (DESCRIPTION = 'Test')" -o "C:\Result.txt"
Modify the Description Label to the correct project name.
Depending on the environment, -S <HostName>\SQLEXPRESS may need to be added after "osql"
