Migrating the code from dev to test and other environments

Dear Experts,

I am trying to get some information on how do you typically handle the migration of code from one environment to another. Right now, we do manual export and imports from dev to qa and from QA to Production.

Does anyone have any experience/ suggestions around how can this be automated? Any helpful links that provide detailed information on this topic that you are aware of?

Thanks in advance for the help.

Which ETL / ELT tools are you using?

You're not one of our customers, but if you were using Ajilius it would be as simple as deploying a folder of scripts and setting some environment variables.

If you're using SSIS, the following thread is old but still contains good advice:

https://msdn.microsoft.com/en-us/library/cc671628.aspx

... and Pragmatic Works' BI-xPress is great value if you're looking for more extensive automation:

http://pragmaticworks.com/Products/BI-xPress