We are moving data from one server to another. The table structures are somewhat different but data is bound to strict constraints from a business and security point of view.
So right now I've created the queries that produce the right data, but they are somewhat large. I'm also supposed to be able to bundle the whole lot and have it executed 'as is' on the production environment.
So I put each query in a separate file and I'm using sqlcmd for exporting. I made a script to execute all queries and dump the data into files. However, I'd rather use bcp instead so I can use format files for both the export and import. The binary data especially proves a bit of a hassle on the other side.
Do you guys have a best practice on this?