Run BCP without SQL Client

Question

I had a Access database, since the database limit is 2 GB, I am planning to migrate to Azure Database. I need to upload data with the help of BCP but I was wondering how users will be able to use it since they wont have SSMS installed in their PC. Please help

Access does provide it's own way of upgrading to a SQL server. Have you tried that? — Krish, Nov 20 '17 at 14:08
@krishKM - Access' built-in SQL Server "upsizing wizard" was removed from Access 2013. — Gord Thompson, Nov 20 '17 at 14:54

score 0 · Answer 1 · answered Nov 20 '17 at 08:08

0

Use either:

SQL Server Migration Assistant (SSMA) v7.3

or perhaps the new (still in preview):

SQL Operations Studio

answered Nov 20 '17 at 08:08

Gustav

53,498
7
29
55

I got the solution. If you do not have sql client installed in your system but want to run BCP, there are 2 softwares need to be installed 1) Microsoft® ODBC Driver 13.1 for SQL Server® 2) MsSqlCmdLnUtils.msi thanks for the help @Gustav – Renjith R Nov 20 '17 at 10:13

Run BCP without SQL Client

1 Answers1