I tried importing into SQL Server (2017 in docker container). The database was completely empty. User vrs is dbowner.
BaseStation Import
Source: [SQLite] /Users/pavel/.local/share/VirtualRadar/BaseStation.sqb
Target: [SqlServer] Server=localhost,1401;UID=vrs; Password=vrs-password1;Database=vrs; (apply schema)
Aircraft: Import / Update
Locations: Import / Update
Sessions: Import / Update
Flights: Import / Update 0001-01-01 to 9999-12-31
[####################] [1 / 1] [100.0%] 00:00:00 Applying schema
[####################] [1 / 1] [100.0%] 00:00:00 Importing locations
[####################] [1,487 / 1,487] [100.0%] 00:00:00 Importing sessions
[ ] [0 / 3,515,555] [0.0%] 00:00:00 Importing aircraft
Caught exception: System.ArgumentException: The parameter data type of System.Data.DataTable is invalid.
at System.Data.SqlClient.SqlParameter.InferSqlType (System.Object value) [0x00049] in <9ec44cbcc9fa4c6b81867c576ebbc98b>:0
at System.Data.SqlClient.SqlParameter.set_Value (System.Object value) [0x00008] in <9ec44cbcc9fa4c6b81867c576ebbc98b>:0
at Dapper.TableValuedParameter.Set (System.Data.IDbDataParameter parameter, System.Data.DataTable table, System.String typeName) [0x00007] in <63a8cc06dfb842f1823bc51677815d4b>:0
at Dapper.DataTableHandler.SetValue (System.Data.IDbDataParameter parameter, System.Object value) [0x00000] in <63a8cc06dfb842f1823bc51677815d4b>:0
at Dapper.SqlMapper+TypeHandlerCache`1[T].SetValue (System.Data.IDbDataParameter parameter, System.Object value) [0x00000] in <63a8cc06dfb842f1823bc51677815d4b>:0
at (wrapper dynamic-method) <>f__AnonymousType11`1[System.Data.DataTable]:ParamInfoa65b1f6a-b417-4973-8cb5-2e6e530e447c (System.Data.IDbCommand,object)
at Dapper.CommandDefinition.SetupCommand (System.Data.IDbConnection cnn, System.Action`2[T1,T2] paramReader) [0x000b4] in <63a8cc06dfb842f1823bc51677815d4b>:0
at Dapper.SqlMapper.QueryMultipleImpl (System.Data.IDbConnection cnn, Dapper.CommandDefinition& command) [0x000d0] in <63a8cc06dfb842f1823bc51677815d4b>:0
at Dapper.SqlMapper.QueryMultiple (System.Data.IDbConnection cnn, System.String sql, System.Object param, System.Data.IDbTransaction transaction, System.Nullable`1[T] commandTimeout, System.Nullable`1[T] commandType) [0x00018] in <63a8cc06dfb842f1823bc51677815d4b>:0
at VirtualRadar.Plugin.SqlServer.BaseStationDatabase+<>c__DisplayClass105_1.<UpsertManyAircraft>b__0 (VirtualRadar.Plugin.SqlServer.ConnectionWrapper wrapper) [0x00039] in <41efae8bf49945009e0487d3b50b2ebd>:0
at VirtualRadar.Plugin.SqlServer.BaseStationDatabase.PerformInConnection (System.Action`1[T] action) [0x0000f] in <41efae8bf49945009e0487d3b50b2ebd>:0
at VirtualRadar.Plugin.SqlServer.BaseStationDatabase.UpsertManyAircraft (System.Collections.Generic.IEnumerable`1[T] upsertAircraft) [0x00048] in <41efae8bf49945009e0487d3b50b2ebd>:0
at BaseStationImport.BaseStationImporter.LoadOrImportAircraft () [0x001d3] in <47632728a6c4447982a62992961cd869>:0
at BaseStationImport.BaseStationImporter.ProcessAircraft () [0x00010] in <47632728a6c4447982a62992961cd869>:0
at BaseStationImport.BaseStationImporter.Import () [0x00012] in <47632728a6c4447982a62992961cd869>:0
at BaseStationImport.CommandRunner_Import.Run () [0x002ca] in <47632728a6c4447982a62992961cd869>:0
at BaseStationImport.Program.Main (System.String[] args) [0x000f9] in <47632728a6c4447982a62992961cd869>:0
Full details have been recorded in the log
New SQL server plugin
Forum rules
Please bear in mind if you do install a preview version that it is unfinished code, there may be bugs, bits missing, things that don't work etc.
Posts in this forum will not show up in forum search results. Old threads will be pruned occasionally.
Please bear in mind if you do install a preview version that it is unfinished code, there may be bugs, bits missing, things that don't work etc.
Posts in this forum will not show up in forum search results. Old threads will be pruned occasionally.