Search code examples
azure-sql-databasesql-loaderazure-sql-server

SQLLDR for Azure SQL Server?

I have bash script running in Ubuntu that uses the SQLLDR to load additional data into Oracle database from CSV file.

We are migrating to Azure SQL server and I am asked to convert the script so that it will load the additional data into Azure SQL server.

How do I do it? I don't want to use ADF, is there any simple solution available ? Can I use Azure SQL BCP to additional data into Azure SQL server and Can it be installed on Ubuntu ?

Solution

  • I could get it done using BCP tool

    bcp Database.Schema.Persons format nul -c -t, -f Categoriesformat.fmt -S tcp:demo.database.windows.net -U User1 -P P@$$word!

bcp Database.Schema.Persons in "W:\test_load_data.csv" -t , -f Categoriesformat.fmt -S tcp:demo.database.windows.net -U User1 -P P@$$word!

    Reference: SQL Server BCP insert additional columns