They would need to be adopted to implement proper error handling etc. Note: The supplied examples does not represent production quality scripts. To run this on a periodic basis please see the section " Using the Microsoft Task Scheduler" below.Edit the runReport.vbs and change the paths to pinpoint the runDbVis.vbs and sendMail.vbs.SELECT TABLENAME FROM INFORMATIONSCHEMA.TABLES The second query will return a list of all the columns and tables in the database you are querying. This first query will return all of the tables in the database you are querying. ![]() Edit the sendMail.vbs script to your needs. To Show the TABLES and COLUMNS in the database or find TABLES and COLUMNS.sqlfile ""C:\Users\ulf\test\folder with space\export.sql""" If the path contains spaces you may need to add some extra double-quotes. The path to the SQL file (-sqlfile parameter).For more information about the Run method see Microsoft Documentation Note the "0" at the end represents the intWindowStyle parameter and means that no window will be shown when running the script.Change the -sqlfile argument to specify the path to the export.sql file.Change part " -connection H2" to "-connection YourConnection" where "YourConnection" denotes the Database name defined in DbVisualizer of the database connection you want to connect to.Change the path pointing out dbviscmd.bat to the DbVisualizer installation on the computer you are running the scripts (I.e change the C:\Program Files\DbVisua.StrReturn = oShell.Run ("""C:\Program Files\DbVisualizer\dbviscmd.bat"" -connection H2 -sqlfile C:\Users\ulf\Desktop\vbs\export.sql", 0, true) ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |