I have Visual Studio Community 2015.
I have an existing table with the correct columns, matching in order and data type the CSV file...
I was expecting something like a right click, import. Seems like such a basic functionality.
What do you recommend?
Right...arghhh...well in that case BCP is the one that can save you and you should run a command like:
bcp database_name.schema.table in C:\import.csv -c -U username @servername -S servername.database.windows.net
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied?
You can use SQL Server Initialize from Backup…