I need directions to where I can download sqlwatchimport.exe prebuilt pls?
The compiled artifacts are included in GitHub Releases (or pre-releases ie betas), as the version 3.0 has not had any release yet, the application is only available as a source code.
In other words, there is nowhere on GitHub to publish compiled application unless it’s released.
However, it should be easy to build the application in Visual Studio from source code.
Hope this makes sense.
Thanks for your reply. Yes I have successfully compiled it now (struggled initially because I didn’t have the commandline libarary).
May I ask one more question? The documentation is a bit sparse. I understand that I can use it with the Add and Update options to register my SQL instances in the central repository. But what is the mechanism to actually import the data in once I have added my SQL instances?
You just run the
SqlWatchImport.exe without any arguments and it will import the data for you.
Awesome. Thank again.
When I run it with the --add option I get this error:
2020-10-10 17:30:18.329 DEBUG Checking if Central Repository is online (Thread: 1)
Invalid column name ‘sql_user’.
It is trying to insert into the table [sqlwatch_config_sql_instance] with column values ‘sql_user’ and ‘sql_secret’ - which don’t exist for that table.
SqlWatch installed version = 2.6
SqlWatchImport installed version = 3.x.2
Your database version must match the console app version.
I uninstalled/reinstalled version 3.0.7 of the database. The add option worked without issues. But now I get this error when I run the import:
2020-10-11 09:50:42.043 SQLWATCH Remote Instance Importer
Imports remote SQLWATCH data into the Central Repository
Marcin Gminski 2020, SQLWATCH.IO
Version: 1.1.7588.12313 (2020-10-10 06:50:26)
2020-10-11 09:50:42.043 DEBUG Application Configuration
CentralRepositorySqlInstance : #removed#
CentralRepositorySqlDatabase : DBA_SQLWATCH
SqlBulkCopy.EnableStreaming : true
SqlBulkCopy.BatchSize : 4000
SqlBulkCopy.BulkCopyTimeout : 300
EnvironmentToProcess : ALL
FullLoad : false
LogFile : SqlWatchImport.log
MaxLogSizeMB : 10
MaxLogFiles : 10
PrintToLogFile : true
PrintToConsole : true
MinThreads : -1
MaxThreads : 0
MinPoolSize : 0
MaxPoolSize : 0
DumpDataOnError : true
ClientSettingsProvider.ServiceUri : (Thread: 1)
2020-10-11 09:50:42.074 DEBUG Checking if Central Repository is online (Thread: 1)
2020-10-11 09:50:42.230 DEBUG Central Repository SQLWATCH Version: “3.0.7544.33251” (Thread: 1)
Unhandled Exception: System.AggregateException: One or more errors occurred. —> System.Data.SqlClient.SqlException: Invalid object name ‘SQLWATCH.dbo.sqlwatch_config_sql_instance’.
Ok I have resolved the error. Looks like somewhere in the import process it is hard-wired to connect to SQLWATCH database name.
Sounds like a bug.Can you raise an issue on GitHub please?
No worries. I have done that now - #213.