tests for importing deploy state, including SQL implementation