Hi Jackie, Thank you for your reply :)
Firstly, I have two databases on my SQL Server. One of them, I was not able to export Data Store Configuration to XML for it. It showed me the error as following screen capture: <http://osgeo-org.1560.x6.nabble.com/file/n5228292/Capture.png> Secondly, for another DB that I have, I successfully export the Data Store Configuration to XML. Also, I made the changes of the XML, and I load the XML file with my SQL Server FDO Data Sources. It showed me the primary key under my SQL Server Spatial View table as following screen capture: <http://osgeo-org.1560.x6.nabble.com/file/n5228292/SuccessfullyToSeePrimaryKeyInFDOToolBox.png> However, when I was trying to use MapGuide Maestro 6.0m4 to update the Configuration Document for my SQL Server feature source. It showed me following error: *Maestro Error Report ==================== Version: 6.0.0.8587 Date: 10/6/2015 10:56:38 AM Message: The remote server returned an error: (559) MgDbException. Details: System.Net.WebException: The remote server returned an error: (559) MgDbException. at System.Net.HttpWebRequest.GetResponse() at OSGeo.MapGuide.MaestroAPI.HttpServerConnection.SetResourceData(String resourceid, String dataname, ResourceDataType datatype, Stream stream, StreamCopyProgressDelegate callback) in c:\working\JenkinsCI\home\slave_win\jobs\Maestro trunk\workspace\OSGeo.MapGuide.MaestroAPI.Http\HttpServerConnection.cs:line 451 at OSGeo.MapGuide.MaestroAPI.PlatformConnectionBase.SetResourceData(String resourceid, String dataname, ResourceDataType datatype, Stream stream) in c:\working\JenkinsCI\home\slave_win\jobs\Maestro trunk\workspace\OSGeo.MapGuide.MaestroAPI\PlatformConnectionBase.cs:line 1214 at OSGeo.MapGuide.ObjectModels.FeatureSource.ExtensionMethods.SetConfigurationContent(IFeatureSource fs, IServerConnection conn, String xmlContent) in c:\working\JenkinsCI\home\slave_win\jobs\Maestro trunk\workspace\OSGeo.MapGuide.MaestroAPI\ExtensionMethods.cs:line 218 at Maestro.Base.Editor.FsEditorOptionPanel.btnEditConfiguration_Click(Object sender, EventArgs e) in c:\working\JenkinsCI\home\slave_win\jobs\Maestro trunk\workspace\Maestro.Base\Editor\FsEditorOptionPanel.cs:line 122 at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnClick(EventArgs e) at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ButtonBase.WndProc(Message& m) at System.Windows.Forms.Button.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)* Also, the Maestro showed me the differences between Source and Target as following screen capture: <http://osgeo-org.1560.x6.nabble.com/file/n5228292/diff.png> -- View this message in context: http://osgeo-org.1560.x6.nabble.com/SQL-Server-Spatial-View-Selection-Issue-tp5228068p5228292.html Sent from the MapGuide Users mailing list archive at Nabble.com. _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
