Copy the tables and data on the remote server to the local database by using a script

EXECsp_addlinkedserver@server='Srv_lnk',@srvproduct="',@provider='SQLOLEDB',@datasrc='Helios01.us.psav.dom\helioslistener'EXECsp_addlinkedsrvlogin'Srv_lnk','false',NULL,'Shinetechpsav','CEJE5R+SP' UseworkforcemanagementBEGINTRY--BEGIN TRANSACTION    DROP TABLECommentsDROP TABLECustomer_excludeDROP TABLEDeptstatusDROP TABLEforecast_hourlyDROP TABLEforecast_revenueDROP TABLEforecast_salaryDROP TABLEForecast_schedule_changeDROP TABLEFreelanceDROP TABLE HistoryDROP TABLEInvgroupDROP TABLELastupdatetablesDROP TABLE [Login]    DROP TABLEnwf_all_employeesDROP TABLEnwf_closed_actualDROP TABLENwf_closed_forecastDROP TABLEnwf_holidaysDROP TABLEnwf_liveDROP TABLENwf_qb_percDROP TABLEnwf_sitesDROP TABLENwf_supervisor_nameDROP TABLEnwf_supervisor_regionDROP TABLENwf_supervisor_siteDROP TABLEOvertime_reportDROP TABLEPaypolicyDROP TABLEquickcommentDROP TABLE RegionDROP TABLESalaryDROP TABLEtransfer_positionsDROP TABLETransfersDROP TABLEUltipro_apiDROP TABLE [Union]    DROP TABLEunion_positionsGO; SELECT *  intoComments fromsrv_lnk.WorkForceManagement.dbo.CommentsSELECT *  intoCustomer_exclude fromSrv_lnk. WorkForceManagement.dbo.Customer_Exclude with(NOLOCK)SELECT *  intoDeptstatus fromSrv_lnk. WorkForceManagement.dbo.DeptStatus with(NOLOCK)SELECT *  intoForecast_hourly fromSrv_lnk. WorkForceManagement.dbo.Forecast_Hourly with(NOLOCK)SELECT *  intoForecast_revenue fromSrv_lnk. WorkForceManagement.dbo.Forecast_Revenue with(NOLOCK)SELECT *  intoForecast_salary fromSrv_lnk. WorkForceManagement.dbo.Forecast_Salary with(NOLOCK)SELECT *  intoForecast_schedule_change fromSrv_lnk. WorkForceManagement.dbo.Forecast_Schedule_Change with(NOLOCK)SELECT *  intoFreelance fromSrv_lnk. WorkForceManagement.dbo.Freelance with(NOLOCK)SELECT *  intoHistory fromSrv_lnk. WorkForceManagement.dbo.History with(NOLOCK)SELECT *  intoInvgroup fromSrv_lnk. WorkForceManagement.dbo.InvGroup with(NOLOCK)SELECT *  intoLastupdatetables fromSrv_lnk. WorkForceManagement.dbo.LastUpdateTables with(NOLOCK)SELECT *  into [Login]  fromSrv_lnk. Workforcemanagement.dbo.[Login]  with(NOLOCK)SELECT *  intoNwf_all_employees fromSrv_lnk. WorkForceManagement.dbo.NWF_All_Employees with(NOLOCK)SELECT *  intoNwf_closed_actual fromSrv_lnk. WorkForceManagement.dbo.NWF_Closed_ACTUAL with(NOLOCK)SELECT *  intoNwf_closed_forecast fromSrv_lnk. WorkForceManagement.dbo.NWF_Closed_FORECAST with(NOLOCK)SELECT *  intoNwf_holidays fromSrv_lnk. WorkForceManagement.dbo.NWF_Holidays with(NOLOCK)SELECT *  intoNwf_live fromSrv_lnk. WorkForceManagement.dbo.NWF_Live with(NOLOCK)SELECT *  intoNwf_qb_perc fromSrv_lnk. WorkForceManagement.dbo.NWF_QB_Perc with(NOLOCK)SELECT *  intoNwf_sites fromSrv_lnk. WorkForceManagement.dbo.NWF_Sites with(NOLOCK)SELECT *  intoNwf_supervisor_name fromSrv_lnk. WorkForceManagement.dbo.NWF_Supervisor_Name with(NOLOCK)SELECT *  intoNwf_supervisor_region fromSrv_lnk. WorkForceManagement.dbo.NWF_Supervisor_Region with(NOLOCK)SELECT *  intoNwf_supervisor_site fromSrv_lnk. WorkForceManagement.dbo.NWF_Supervisor_Site with(NOLOCK)SELECT *  intoOvertime_report fromSrv_lnk. WorkForceManagement.dbo.OverTime_Report with(NOLOCK)SELECT *  intoPaypolicy fromSrv_lnk. WorkForceManagement.dbo.PayPolicy with(NOLOCK)SELECT *  intoQuickcomment fromSrv_lnk. WorkForceManagement.dbo.QuickComment with(NOLOCK)SELECT *  intoRegion fromSrv_lnk. WorkForceManagement.dbo.Region with(NOLOCK)SELECT *  intoSalary fromSrv_lnk. WorkForceManagement.dbo.Salary with(NOLOCK)SELECT *  intoTransfer_positions fromSrv_lnk. WorkForceManagement.dbo.Transfer_Positions with(NOLOCK)SELECT *  intoTransfers fromSrv_lnk. WorkForceManagement.dbo.Transfers with(NOLOCK)SELECT *  intoUltipro_api fromSrv_lnk. WorkForceManagement.dbo.UltiPro_API with(NOLOCK)SELECT *  into [Union]  fromSrv_lnk. Workforcemanagement.dbo.[Union]  with(NOLOCK)SELECT *  intoUnion_positions fromSrv_lnk. WorkForceManagement.dbo.Union_Positions with(NOLOCK)--COMMIT TRANSACTIONENDTRYBEGINCATCH--ROLLBACK TRANSACTIONENDCatch

Copy the tables and data on the remote server to the local database by using a script