Import data SQL Azure Cloud database from SQL Server 2008
https://sqlserver2014tutorial.com/
In this training demo on SQL Azure, we demonstrate how to export data from local on premise SQL 2008 and import data to SQL Azure in the cloud environment. First using transacts SQL we create the destination table in Azure SQL. Using Business Intelligence Development Studio (BIDS) to create a SQL Server Integration Services (SSIS) project. After local and cloud data source are configured, we configure a Data Flow task using the Control Flow tab in Visual Studio. We create an OLE DB data source and an ADO Net destination that points to the cloud SQL azure database. We make sure the column mappings between the source and the destination databases are good. We go ahead and execute the SSIS package, this fails on the first attempt. We do a little troubleshooting and find out the issue between the two SQL tables. We fix the issue and rerun Integration Services package to finally move the data from local SQL database to the Cloud database.
Visit our other sites:
https://www.learningcomputer.com
https://datatechnologyllc.com
https://sqlserver2014tutorial.com/