V2 den V5 Müşteri Aktarımı

SELECT REPLACE('INSERT INTO [Entities] ([EntityTypeId],[LastUpdateTime],[SearchString],[CustomData],[Notes],[AccountId],[WarehouseId],[Name]) VALUES (1,getdate(),NULL,%%%[{"Name":"Telefon","Value":"'+PhoneNumber+'"},{"Name":"Adres","Value":"'+Address+'"}]%%%,NULL,0,0,%%%'+Name+'%%%)','%%%',CHAR(39)) FROM [Customers]

image

20sn de 20.000 kişi ekleniyor