Very interesting discussion, I'm still digesting everything! I intended this to be more of an open discussion but I will relate the problem I am working on that triggered me to ask this question.
I asked this question as I was trying to write down my model equation for gravity draining my storage tank (CIP waste, oil-water emulsion product, and animal oil) into a frac tank for waste disposal; my worst case waste profile still puts my solution to about the same density and viscosity of water. The bottom outlet nozzle of the tank (Cd=0.8 for a square mouth) is about 2 feet up from the top of the frac tank, so I wanted to calculate the degree to which the static pressure from the level in the frac tank will affect the transfer and work out if there would be any spill scenarios. My tank is 9 feet inner diameter and my outlet nozzle is 2 inches inner diameter, well withing the scenario LittleInch described! In imagining the scenario, I knew I wanted to use a psuedo-steady state approx. to make my model and I was trying to make sure my assumptions are justified so I went off thinking about some extreme cases.
Further info about the tank: outlet nozzle connects to a 1 inch 90 with a flange that is connected to a 2" CS pipe that is about 5 feet in length, which connects to 2" 90 (this brings the CS pipe through the containment basin) followed by another 3 foot run of the CS pipe and ends at a 3 inch ball valve (SS construction). I attached a sketch of the setup.
I used the psuedo-steady state approx. of 0 m/s for the velocity of the water at the surface of the higher elevation (surface in the tank). This would reduce my energy balance (Bernoulli eqn.) to change in potential energy of the stored liquid in the storage tank to the kinetic energy into the frac tank minus the losses in the flow path. I would use the Cd as part of my "losses" term along with friction factor calcs of the pipes, hoses, and valves. Once I derive a relationship for the velocity into the frac tank, I can figure out the height in the frac tank to understand if the level in the frac tank will equilibrate somewhere other than the top of the frac tank.
g*zwater surface height in tank = 0.5*(vinto frac)^2-"LOSSES"+g*zwater surface height in tank
My comment about the pump was more so my opinion on the inherent over-sizing in may of the guidelines I read, but I don't doubt I'd be able to prime a pump if I were to use one. I will admit that my understanding of pumps is very rudimentary, which is why I frequent the pump engineering forum as much as I can.
(edited to clarify diameter, provide additional details of the tank, and attached sketch.)