1
Vote

Moving only certain rows from a table

description

We are moving our desktop applications to cloud. From time to time we want to migrate the data from the local on-premise server to cloud. I am using this SQL migration tool and it works beatutifully but it takes a long time as we have a lot of data. Wondering if there is a way i can specify SQL statements for table to determine which rows need to be exported.

Thanks a lot in advance.

comments

ghuey wrote Jul 7, 2016 at 7:30 PM

Hi,

I am sorry, but there is no easy way with SQLAzureMW to BCP out a subset of rows for a given table. You would have to purge the records you don't want before running SQLAzureMW.

Sorry,
George