I have the following situation:
In my production DB, i want to save the contents of a table to my local DB copy.
In my production DB DB_PRODUCTION: i have the table Company with all the live data.
What I want to do is to copy the contents of the Company table into the Company Table of my test environment (that is located on a local server).
How can I do this without taking a complete backup of the DB_PRODUCTION database?
What I wanted to do is to perform a spanSELECT * FROM Company query on the production DB, save the result to .csv and import it in my DB_TEST database.
But is this even supported/Possible?
The version is SQL Server 2013 (Production) and SQL Server 2016 (Test)