2 Networks connected to 1 workstations - config

Hello,
I’m in the process of setting up 2 LAN networks at home. This project is calling for each Database server to be on a separate and preferably 1Gb network. Please see attached sketch.

I’m not sure how to configure details of the each server and the each work station. When I set these up with a static IP address, it does not work. Static address id all I’ve setup so far, not sure if I need a router as well on the Database network or just switch ( which is what I have so far ) .
I can’t ping the Database server, I have no idea about advance setup I may need to do.

Thanks

win 10 ( 10.0.18363 )

Berton said:

First, glad to see the proper use of the contraction Gb for Gigabit, usually see GB wrongly used. Traditionally b = bit and B = Byte, 8 bits = 1 Byte.

Second, is the top unit in your picture a Switch or Hub? I add an 8-port or 5-port Switch to the 4-port Router when needing more Ethernet ports for devices, have you tried a Router instead of the Switch, shouldn't need to be connected to the Internet. Only suggestions I have except the top server may need a cross-over Ethernet cable or computer to computer, not sure on that as the Switch should handle it.

Top device is a switch , I don't have another router. any idea why I can not ping the database server ? , I'm only showing one workstation but once its working thee will be 3 workstations.

Thanks

You may need to setup a route cmd it will depend in the matrix set so ping would only go via the highest matrix. Why must the data base be on different networks?

Caledon Ken said:

Possible answer is your ping is not from the appropriate NIC. It may try to ping from the NIC with router.

Or your switch is not handling any routing.

Thanks , how would I ping from a specific NIC ?

- - - Updated - - -

Samuria said:

You may need to setup a route cmd it will depend in the matrix set so ping would only go via the highest matrix. Why must the data base be on different networks?

Thank you ,

- how would I set this route command ? or could you please point me in right direction ?

- The software is Davinci Resolve by Black Magic Design. When I first started at looking at this setup I checked with the publisher and this is what they said: