Personalized Community is here!
Quickly customize your community to find the content you seek.
‘Better Together’ Integration forum available
We're launching a how-to forum where you can learn and engage about how Dynamics 365 integrates with other Power Platform products.
Read about Better Together forum
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 2 virtual launch event
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 | 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