Breaking news from around the world
Get the Bing + MSN extension
Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, PowerApps, Microsoft Flow, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates to Dynamics 365Release overview guides and videos Release Plan | Early Access Availability
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
In this post, we will talk about how to copy data of a table from one database to another using Azure.
Here we are using the following Azure resources:
To begin, let’s login to Azure portal. After successful login let’s go through the below steps to see it in action.
1. Create Azure SQL Server:
Click on Create a resource in Azure portal –> Search for SQL Server(logical..
On the next screen, Click Create
Fill the mandatory fields and click on Create.
2. Create Azure SQL Database:
After creating the Azure SQL Server, let’s create 2 Azure SQL databases:
i) SourceSQLDB and ii) DestinationSQLDB
Click on Create a resource –> Select Databases –> SQL Database
To create Source Database, fill the mandatory fields and click on Create. Select Server as adf(the one we have created in the first step). For demo purpose, we have selected Source as Sample(AdventureWorksLT) to have some sample data as shown below:
Similarly let’s create Destination Database. Select Server as adf(the one we have created in the first step).
Once we are done with creating SQL server and SQL databases, let’s create a view in the source DB from the sample tables/data([SalesLT].[Customer]) we have in the source DB.
create view [dbo].[CustomersView]
In this demo, we’ll copy the data from the above view to a table in the destination DB. Let’s create a table in destination DB to which data will be copied.
CREATE TABLE [dbo].[CustomersView](
[CustomerID] [int] IDENTITY(1,1) NOT NULL,
[Title] [nvarchar](8) NULL,
[FirstName] [varchar](100) NOT NULL,
[MiddleName] [varchar](100) NULL,
[LastName] [varchar](100) NOT NULL,
[Suffix] [nvarchar](10) NULL,
[CompanyName] [nvarchar](128) NULL
Below is the summary of what we have done so far:
Once, we are done with creating view in source DB and table in destination DB for copying data, let’s proceed with creating Azure Data Factory which we will discuss in the next post.
Business Applications communities