MINID=0
MAXID=1000000
STEP=1000
MIGRATE_USER=''
PASSWORD=''
HOST=''

for ((i=$MINID; i<=$MAXID; i+=$STEP)); do
echo -n "$i";
mysql -u $MIGRATE_USER -p$PASSWORD -h $HOST edxapp<<EOF
INSERT INTO edxapp.oauth_dispatch_scopedapplication (client_id, redirect_uris, client_type, authorization_grant_type, client_secret, name, user_id, skip_authorization)
  SELECT client_id, redirect_uris, client_type, authorization_grant_type, client_secret, name, user_id, skip_authorization
  FROM edxapp.oauth2_provider_application
  WHERE id BETWEEN $i AND $(($i+$STEP-1));

EOF
echo '.';
sleep 2
done