AdminServers/ASV - Revision history

Kia: /* SQL Server */

2022-05-20T07:36:55Z

SQL Server

← Older revision		Revision as of 07:36, 20 May 2022
Line 2:		Line 2:

	====SQL Server====		====SQL Server====
	DNS or IP address of the ~~Microsoft SQL~~ server where the database is stored.		DNS or IP address of the Postgres server where the database is stored.

	====Database====		====Database====

2022-05-20T07:36:28Z

← Older revision		Revision as of 07:36, 20 May 2022
Line 1:		Line 1:
	[[File:AdminServer ASV.jpg\|none\|thumb\|656x656px]]		[[File:AdminServer ASV.jpg\|none\|thumb\|656x656px]]

	====~~Full path and name to database~~====		====SQL Server====
	~~A file copy~~ of the ~~production~~ database ~~from ASV~~.		DNS or IP address of the Microsoft SQL server where the database is stored.

	====~~Path to java.exe~~====		====Database====
	~~[https://www.java.com/en/download/ Java] needs to be installed on the UMS server~~.		Database name.

	====~~Path to H2 bin folder~~====		====Port number====
	~~[https://www~~.~~h2database~~.~~com/html/download.html H2] needs~~ to ~~be installed on the UMS server~~.		The port number of the SQL server.

			====Username====
			SQL Username to access database.

			====Password====
			SQL Password to access database.

	===[[AdminServers/Export Settings\|Export settings]]===		===[[AdminServers/Export Settings\|Export settings]]===

2022-01-13T10:31:35Z

Staff

← Older revision		Revision as of 10:31, 13 January 2022
Line 486:		Line 486:
	\|}		\|}

	=== Requirements for extracting to UMS ===		===Requirements for extracting to UMS===

	~~==== Staff ====~~
	~~PKZ must be filled.~~

			====Staff====
	He must be active in the current school year.		He must be active in the current school year.

Line 497:		Line 495:
	ABGANG_DATUM if entered and lower than today + keep alive then he won't be extracted		ABGANG_DATUM if entered and lower than today + keep alive then he won't be extracted

	==== Student ====		====Student====
	He must be active in the current school year.		He must be active in the current school year.

2022-01-13T08:23:39Z

FAQ

@@ Line 485: / Line 485: @@
 |This is the student year level
 |}
 =FAQ=

2021-09-13T13:56:49Z

Data mapping

2021-01-18T11:54:01Z

Bat script to copy ASV db to UMS server

← Older revision		Revision as of 11:54, 18 January 2021
Line 486:		Line 486:
	You need to create a scheduled task on the ASV server that runs this bat script.		You need to create a scheduled task on the ASV server that runs this bat script.
	net stop asv-server		net stop asv-server
	xcopy /H D:\ASVak\database\asv.mv.db \\W1-UMS-Server.W1.local\c$\ASV ~~<c:\bat\ja.txt~~		md \\W1-UMS-Server.W1.local\c$\ASV
			xcopy /H D:\ASVak\database\asv.mv.db \\W1-UMS-Server.W1.local\c$\ASV /y /j
	net start asv-server		net start asv-server

	===Connect with H2===		===Connect with H2===
	[[File:Adminserver ASV H2 Connection.jpg\|none\|thumb\|438x438px]]		[[File:Adminserver ASV H2 Connection.jpg\|none\|thumb\|438x438px]]

2021-01-18T11:40:35Z

Bat script to copy ASV db to UMS server

← Older revision		Revision as of 11:40, 18 January 2021
Line 483:		Line 483:
	=FAQ=		=FAQ=

	=== Bat script to copy ASV db to UMS server ===		===Bat script to copy ASV db to UMS server===
			You need to create a scheduled task on the ASV server that runs this bat script.
	net stop asv-server		net stop asv-server
	xcopy /H D:\ASVak\database\asv.mv.db \\W1-UMS-Server.W1.local\c$\ASV <c:\bat\ja.txt		xcopy /H D:\ASVak\database\asv.mv.db \\W1-UMS-Server.W1.local\c$\ASV <c:\bat\ja.txt
	net start asv-server		net start asv-server
	~~<br />~~

	===Connect with H2===		===Connect with H2===
	[[File:Adminserver ASV H2 Connection.jpg\|none\|thumb\|438x438px]]		[[File:Adminserver ASV H2 Connection.jpg\|none\|thumb\|438x438px]]

2021-01-18T11:39:27Z

Bat script to copy ASV db to UMS server

← Older revision		Revision as of 11:39, 18 January 2021
Line 484:		Line 484:

	=== Bat script to copy ASV db to UMS server ===		=== Bat script to copy ASV db to UMS server ===
	net stop asv-server		net stop asv-server
			xcopy /H D:\ASVak\database\asv.mv.db \\W1-UMS-Server.W1.local\c$\ASV <c:\bat\ja.txt
			net start asv-server
			<br />

	~~xcopy /H D:\ASVak\database\asv.mv.db \\W1-UMS-Server.W1.local\c$\ASV <c:\bat\ja.txt~~

	~~net start asv-server~~
	~~<br />~~
	===Connect with H2===		===Connect with H2===
	[[File:Adminserver ASV H2 Connection.jpg\|none\|thumb\|438x438px]]		[[File:Adminserver ASV H2 Connection.jpg\|none\|thumb\|438x438px]]

2021-01-18T11:39:19Z

FAQ

← Older revision		Revision as of 11:39, 18 January 2021
Line 483:		Line 483:
	=FAQ=		=FAQ=

			=== Bat script to copy ASV db to UMS server ===
			net stop asv-server

			xcopy /H D:\ASVak\database\asv.mv.db \\W1-UMS-Server.W1.local\c$\ASV <c:\bat\ja.txt

			net start asv-server
			<br />
	===Connect with H2===		===Connect with H2===
	[[File:Adminserver ASV H2 Connection.jpg\|none\|thumb\|438x438px]]		[[File:Adminserver ASV H2 Connection.jpg\|none\|thumb\|438x438px]]

2021-01-15T11:53:59Z

Connect with H2

← Older revision		Revision as of 11:53, 15 January 2021
Line 483:		Line 483:
	=FAQ=		=FAQ=

	=== Connect with H2 ===		===Connect with H2===
	[[File:Adminserver ASV H2 Connection.jpg\|none\|thumb\|438x438px]]		[[File:Adminserver ASV H2 Connection.jpg\|none\|thumb\|438x438px]]
	You need to change the path after localhost in the JDBC URL to match your location of the ASV database.<br />		You need to change the path after localhost in the JDBC URL to match your location of the ASV database.

			User Name and password is blank.<br />