1
Vote

Crashed on last step: Scripting

description

On the last step where the application starts scripting it crashed,I've tried to debug the application to see what exactly is the issue and it was "Index was outside the bounds of the array." , here's the stacktrace:
 
at SQLAzureMWUtils.ScriptDatabase.ScriptTableData(SqlSmoObject obj, StringCollection& bcpOutputCommands, StringCollection& bcpTargetCommands, String& outputDir)
at SQLAzureMWUtils.ScriptDatabase.ScriptTables(SqlSmoObject[] smoObjects, StringCollection& tableForeignKey, StringCollection& bcpOutputCommands, StringCollection& bcpTargetCommands, String& outputDir)
at SQLAzureMWUtils.SourceProcessor.Process(SqlSmoObject[] objects, Int32 start)
at SQLAzureMW.ScriptWizard.GenerateScriptFromSourceServer()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()

comments

ghuey wrote Sep 11, 2012 at 11:20 AM

Hi,

What version of SQL Server are you running on your local machine that you are running SQLAzureMW on? Also, were you running against SQL Server or Azure SQL Database?

I am on the road this week, so my response will be a little slow. Hopefully we can get this figured out soon.

Regards,
George

Alaa9jo wrote Sep 11, 2012 at 12:36 PM

Thanks for your response.

My PC have SQL server 2008 R2 Express SP1 10.50.2500.0 , my sql database is on a server within the same network and it has sql server Enterprise 2005,so as you can see I'm running against SQL Server database not Azure Database.

ghuey wrote Sep 11, 2012 at 7:00 PM

I can't find the issue on my machine. If you don't mind, contact me via Codeplex and we can take this offline. If nothing else, I can send you a debug build that we can use to trace down the problem.

Thanks for your time,
George

ghuey wrote Sep 19, 2012 at 6:09 PM

Thanks very much for your help. I posted the fix in v3.9.6.

Regards,
George