What are the challenges you face when working across database platforms? Take the survey
Options

Run SQL Data Compare with command line

I am trying to run the tool using the command line. I have a project file which I want my run to be based on. 
I run using the following command:


SQLDataCompare.exe /project:Argfile:E:\RedGateProjects\CalcCompare.sdc /out:E:\CompareReports\FirstTest.csv

And I am getting the following error:

Error: Unhandled exception
The given path's format is not supported.
System.NotSupportedException
   at System.Security.Permissions.FileIOPermission.EmulateFileIOPermissionChecks(String fullPath)
   at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
   at System.IO.StreamReader..ctor(String path, Encoding encoding, Boolean detectEncodingFromByteOrderMarks, Int32 bufferSize, Boolean checkHost)
   at System.IO.StreamReader..ctor(String path, Boolean detectEncodingFromByteOrderMarks)
   at RedGate.Legacy.Serialization.XMLSerializeFormatter.DeserializeRootObject(String fileName, String name, String typeName)
   at RedGate.SQLCompare.Engine.Project.TryDeserialization(ISerializeFormatter serialization, String fileName, String typeName, Boolean& fileError, Exception& rethrowException)
   at RedGate.SQLCompare.Engine.Project.LoadFromDisk(String fileName)
   at RedGate.SQLToolsCommandLine.CommandProcessor.LoadProjectFromDisk(String filename)
   at RedGate.SQLToolsCommandLine.CommandProcessor.ProcessProjectFile(String filename, Project project)
   at RedGate.SQLToolsCommandLine.CommandProcessor.InitializeProject()
   at RedGate.SQLDataCompare.CommandLine.DataCommandProcessor.LoadProject()
   at RedGate.SQLToolsCommandLine.CommandProcessor.ProcessCommands()
   at RedGate.SQLToolsCommandLine.CommandProcessor.Run()
   at RedGate.SQLDataCompare.CommandLine.Startup.Start(String[] args)


What is the problem here?

Best Answer

Sign In or Register to comment.