SQLUpdateProvider 1.0.7
dotnet add package SQLUpdateProvider --version 1.0.7
NuGet\Install-Package SQLUpdateProvider -Version 1.0.7
<PackageReference Include="SQLUpdateProvider" Version="1.0.7" />
paket add SQLUpdateProvider --version 1.0.7
#r "nuget: SQLUpdateProvider, 1.0.7"
// Install SQLUpdateProvider as a Cake Addin #addin nuget:?package=SQLUpdateProvider&version=1.0.7 // Install SQLUpdateProvider as a Cake Tool #tool nuget:?package=SQLUpdateProvider&version=1.0.7
SQLUpdateProvider
Routine zum automatischen Ausführen von beliebigen SQL-Skripten
Funktionsumfang
- Insert-/Update-Statement: Tables
- Create-/Alter-Statement: Views, Functions, Stored Procedures
- IF-Condition
- Select-Statement
Als übergabeparameter der exe-Datei muss der Importpfad übergeben werden. Die Zugangsdaten müssen in der Erfassungsmaske eingegeben werden. Mit einem Klick auf "Ausführen" werden alle Dateien, die mit .sql enden, in den Microsoft SQL-Server importiert.
.NET Core Bemerkungen
.NET Core 3.1 oder neuer wird vorausgesetzt.
Installationsanleitung für SQL Update Provider binaries
- Installiere .NET Core 3.1 Download: https://dotnet.microsoft.com/en-us/download/dotnet/3.1
- Lade die Datei Sage-100-MetadataDrop.zip herunter
- Entpacke die Datei Sage-100-MetadataDrop.zip
- Starte die Datei Sage.100.ISB.MetadataDrop.exe
Übergabeparameter
Möglichkeit 1 - mit UI:
- [0] - Pfad
Möglichkeit 2 - ohne UI:
- [0] - Pfad
- [1] - SQL-Server
- [2] - SQL-Database
- [3] - SQL-Username
- [4] - SQL-Password
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. |
.NET Core | netcoreapp3.1 is compatible. |
.NET Framework | net48 is compatible. net481 was computed. |
-
.NETCoreApp 3.1
- System.Data.SqlClient (>= 4.8.3)
-
.NETFramework 4.8
- System.Data.SqlClient (>= 4.8.3)
NuGet packages (1)
Showing the top 1 NuGet packages that depend on SQLUpdateProvider:
Package | Downloads |
---|---|
SQLUpdateProviderUI
Module for automatically running one or more SQL scripts on a Microsoft SQL Server database. Incl. WPF UI for database connection configuration |
GitHub repositories
This package is not used by any popular GitHub repositories.