1. Create data with excel template
2. Copy & paste to SQL Server Managment studio
3. Insert into local mysql database (Link server need to be configured in advance)
INSERT OPENQUERY(MYSQLLOCAL,'SELECT * FROM pollexsurvey.pls_respondent') SELECT * FROM pls_respondent WHERE uid > 4280;
INSERT OPENQUERY(MYSQLLOCAL,'SELECT * FROM pollexsurvey.pls_respondent_role') SELECT * FROM pls_respondent_role WHERE respondent_uid > 4280;
INSERT OPENQUERY(MYSQLLOCAL,'SELECT * FROM pollexsurvey.pls_respondentdetail_extsat2017') SELECT * FROM pls_respondentdetail_extsat2017 WHERE uid > 4280;
4. Delete data of earlier batches
delete from pollexsurvey.pls_respondent WHERE uid <=4280;
delete from pollexsurvey.pls_respondentdetail_extsat2017 WHERE uid <=4280;
delete from pollexsurvey.pls_respondent_role WHERE respondent_uid <=4280;
select count(*) from pollexsurvey.pls_respondent;
select count(*) from pollexsurvey.pls_respondentdetail_extsat2017;
select count(*) from pollexsurvey.pls_respondent_role;
5. Export the SQL
