use t25m001


insert into account_master
SELECT     AccCode, AccName, AccType, AccAgentCode, AccGroupCode, AccAdd1, AccAdd2, AccAdd3, AccCityName, AccCityPin, AccPhone, AccMobile, AccFax, AccEmail, AccResident, AccGSTNo, AccCSTNo, 
                      AccPANNo, AccVATNo, AccContPerson, AccRef, AccCrLimit, AccCrDays, 0, 'Dr', 0, AccTANNo, AccKSTNo, TDSYesNo, TDSAccount, JobType, DiscPerc, RDPerPcs, 
                      RDPerMts, InsPolicyNo, Dhara, DharaDays, TransName, AccAdd21, AccAdd22, AccAdd23, AccCityName2, AccCityPin2, BlackListed, BankDetail, ExcessRate, SeriesName, CommPerc, TDSLimit, 
                      BankName, AccountNo, IFSCCode, Branch, LessDays, PackPerPcs, BankCommPerc, BankCommLessPerc, PackPerMts, PostageCharge, Taxable, GSTIN, CompScheme, GSTCategory, ECommGSTIN, 
                      GSTRegDate, AccManager, CityDistanceKM, SMAccCode, TCSApplicable, TCSCollectFrom, UdyamRegNumber, EnterpriseType, EnterpriseActivity
FROM         common.dbo.ACCOUNT_MASTER where acccode collate database_default not in (select acccode from t25m001.dbo.ACCOUNT_MASTER)