title: Move data from one database to another in Azure
body: <p>I'm in the process of migration from dedicated servers to Azure. In my existing SQL Server, I have a few jobs that move data from live database to archives.</p>
  
  <p>From what I have read so far, in Azure you cannot use cross database scritps. The other options I have seen include <a href="https://azure.microsoft.com/en-us/documentation/articles/sql-database-get-started-sql-data-sync/" rel="nofollow">Azure SQL Data Sync</a>, <a href="https://azure.microsoft.com/en-us/documentation/articles/data-factory-azure-sql-connector/" rel="nofollow">Azure Factory</a> and maybe SSIS. I have to note that there's some logic on what data is archived and I need the ability to specify this in the query.</p>
  
  <p>Has anyone some experience and what would you recommend?</p>
  
  <p>Thanx</p>