Import only subset of data

Dec 16, 2010 at 11:33 AM


it is possible to import only subset of data from local sql server? For example from 50 000 entities i want only import 10 000.


Best Regards

Anton Kalcik


Dec 17, 2010 at 6:05 PM


From SQLAzureMW, I don't provide that functionality, BUT, you can do what you want with BCP.  BCP lets you specify first row and last row, lets you build a query so that you can select specific records.  Then you can upload your data.  Anyway, you can use SQLAzureMW to migrate the database objects without the data and then just use your own BCP commands.  Should work great.