• Blog
  • Contact
  • Sign in
CloverDX
Product
  • Overview
  • CloverDX Data Integration Platform
  • What's new in CloverDX 6
  • Pricing
  • CloverDX plans
  • Deployment
  • CloverDX on AWS
  • CloverDX on Azure
  • CloverDX on Google Cloud
  • CloverDX on-premise
  • Resources
  • Customer Portal
  • Documentation
  • Downloads & Licenses
  • Webinars
  • Academy & Training
  • Release Notes
  • CloverDX Forum
  • CloverDX Blog
  • Tech Blog
  • Other resources
isometric-illustration--product@2x 1

Get under the hood of CloverDX

See how CloverDX can benefit your business with a live demo. Simply get in touch with our team and we’ll handle the rest.

Book a demo
Solutions
  • By Industry
  • Banking
  • Capital Markets
  • Consultancy & Advisory
  • FinTech
  • Government Agencies
  • Healthcare
  • By Use Case
  • Data Quality
  • Data Ingest
  • Data Warehousing
  • Data Migration
  • Digital Transformation
  • Enterprise Data Management
  • Risk & Compliance
  • Anonymization
How F3 Group use CloverDX to ingest more client data - webinar
Customer interview

Formula 3: Staying Small And Agile While Working With Large Enterprise Ecosystems

Browse webinars
Services
  • Services
  • Onboarding & Training
  • Professional Services
  • Customer Support

More efficient, streamlined data feeds

Discover how Gain Theory automated their data ingestion and improved collaboration, productivity and time-to-delivery thanks to CloverDX.

 

Read case study
Customers
  • By Use Case
  • Analytics and BI
  • Data Ingest
  • Data Integration
  • Data Migration
  • Data Quality
  • Data Warehousing
  • Digital Transformation
  • By Industry
  • App & Platform Providers
  • Banking
  • Capital Markets
  • Consultancy & Advisory
  • E-Commerce
  • FinTech
  • Government
  • Healthcare
  • Logistics
  • Manufacturing
  • Retail
Migrating data to Workday - case study
Case study

Effectively Migrating Legacy Data Into Workday

Read customer story
Company
  • About CloverDX
  • Our story & leadership
  • Contact us
  • Partners
  • CloverDX Partners
  • Become a partner
Pricing
Demo
Trial

How to Import Data into Azure SQL Database

Data Processing Data Pipelines Data Architecture
Posted October 21, 2019
2 min read
How to Import Data into Azure SQL Database

By the end of 2020, 67 percent of enterprise infrastructure will live in the cloud, and Azure is taking a large piece of that pie.

But, with 80 percent of data migration projects running over time and/or budget, it’s clear that most businesses have room for improvement when it comes to moving data.

With these facts in mind, it’s a good time to brush up on the fundamentals of using Azure SQL database.

Cracking the build vs buy dilemma - get the ebook

Methods for importing and exporting data in SQL Azure database

Frankly, you’re spoiled for choice with methods for moving data with Azure.

Here are the most common methods:

    • Use Transact-SQL statements. Using the commands, BULK INSERT or OPENROWSET (BULK…), you can import data. These commands typically run in SQL Server Management Studio (SSMS).
    • Import using the Flat File Wizard. Using the Import Flat File Wizard in SSMS, you can import a text file into SQL server. This is best to do if you don’t need the configuration options in the Import and Export Wizard. If you need more help, Microsoft have a guide that gets into the weeds.
    • SQL Server Import and Export Wizard. If you have SQL Server Integration Services (SSIS) or SQL Server Data Tools (SSDT) installed, you can use the SQL Server Import and Export Wizard to import and export data.

Ebook - Migrating data workloads to cloud - download now

Loading data from a CSV into Azure SQL Database

Another way to load data is to use the BCP command-line utility to import data from a CSV file into Azure SQL database.

Here’s how:

  1. Create a destination table. Define a table in SQL Database as the destination table. Ensure the columns in the table correspond to the data in each row of your data file.
  2. Create a source data file.
  3. Load the data. Open a command prompt, run the correct command, replacing the values for Server Name, Database name, Username, and Password with your own information.

Azure SQL database is well-optimized for users to move data around in a way that suits them. However, manually moving data with the methods we’ve covered isn’t the best solution for every business.

Book a free demo CloverDX CTA

Life’s too short to wait on data

Moving data to/from Azure isn’t rocket science, but implementing it manually can be both problematic and time-consuming. That’s because writing and executing code can lead to errors and incorrect formatting, which ends up slowing data processes. Manual implementation also leads to costly errors further down the road.

The worst part? As your datasets grow in scale, and you go from terabytes to petabytes, these issues become even more problematic.

Automating the process, with a tool like CloverDX, dramatically improves this process. Error handling, sequencing of steps, ensuring data is on time - these are all easier when you automate your pipelines.

So, if you want to see how an automated solution can help you modernize and accelerate your data pipelines, download a free trial of CloverDX today.

 

Share

Facebook icon Twitter icon LinkedIn icon Email icon
Try CloverDX for 45 days  Full access to Tech Support as if you were a customer

Newsletter

Subscribe

Join 54,000+ data-minded IT professionals. Get regular updates from the CloverDX blog. No spam. Unsubscribe anytime.

Related articles

Back to all articles
buying data integration software
Data Architecture
7 min read

Dos and don'ts when buying a data integration platform

Continue reading
Data architecture health check - do you have these symptoms?
Data Architecture
7 min read

Data architecture health check: Do you have these symptoms?

Continue reading
What is modern enterprise data architecture?
Data Architecture
5 min read

What is modern enterprise data architecture?

Continue reading
CloverDX logo
Book a demo
Get the free trial
  • Company
  • Our story
  • Contact
  • Partners
  • Our partners
  • Become a partner
  • Product
  • Platform overview
  • Plans & Pricing
  • Customers
  • By Use Case
  • By Industry
  • Deployment
  • On-premise
  • AWS
  • Azure
  • Google Cloud
  • Services
  • Onboarding & Training
  • Professional Services
  • CloverCARE Support
  • Resources
  • Customer Portal
  • Documentation
  • Downloads & Licenses
  • Webinars
  • Academy & Training
  • Release Notes
  • CloverDX Forum
  • CloverDX Blog
  • Tech Blog
  • Other resources
Blog
Why data accessibility is essential for your digital transformation
Data Integration
4 barriers to making data-driven decisions
Data Strategy
4 steps to providing a data-driven customer experience
Data Integration
Implementing data democratization: 3 ways to make your data more accessible
Data Innovation
© 2023 CloverDX. All rights reserved.
  • info@cloverdx.com
  • sales@cloverdx.com
  • ●
  • Legal
  • Privacy Policy
  • Cookie Policy
  • EULA
  • Support Policy