Errors when loading db.

Jan 4, 2011 at 7:09 PM


This looks like the tool I need, however when I create a project and it is reading it, it throws an error while reading in SPROCs. The list of sprocs is truncated in the tree view. But on Disk, the scripts for the ones missing in the treeview are present. When DBSourceTools was trying to read the SPROCs, an error window appeared, but there was nothing in it. Is there an error log written someplace? Any work arounds?



Feb 1, 2011 at 7:23 AM

hey Harold,

Unfortunately there are no error logs.  You will have to try downloading the source and putting in some breakpoints.

The tool does a 2-pass scripting run - firstly to script all objects to disk, and then to build the dependency tree.

If the scripts are on disk, then chances are it is failing in the dependency tree code.

Try some breakpoints in the following places:

DBSourceToolsLib.SysObjects.SysObjects.cs => void LoadFromDB( EventHandler<ProgressEventArgs> localHandler)

or maybe here:

DBSourceToolsLib.SysObjects.SODependencyTree.cs => LoadFromDatabase( EventHandler<ProgressEventArgs> localHandler)

Let me know what you find.

- Nathan.