Tests copy functionality for all data source types