Are you using the Upsizing Wizard? If so, have you gotten the latest and greatest from Github/VFPX? Itβs been updated a few times over the years and one of the changes IIRC was to better handle newer versions of SQL. Well, newer than what was around at the time. π Highly recommended. Using SQL 2008? Not so much... π
<https://github.com/VFPX/UpsizingWizard> -- rk From: ProfoxTech <profoxtech-boun...@leafe.com> On Behalf Of Graham Brown Sent: Thursday, October 5, 2023 12:35 PM To: profoxt...@leafe.com Subject: RE: FW: SQL Upsize Hi Thanks Yes, the database and tables all get created via the upsizing wizard so definitely something to do with the data itself The upsizing wizard has worked in the past probably 2000 to 2005 but won't work in 2008r2. Havent done one of these in a long time. In the upsizing wizard I uncheck indices, integrity etc etc but made no difference I have created a simple prg to create a cursor adapter on the local data and another on the server data. This does scatter and gather between the two but on a table with 500k records it takes two days to run so too slow. The next thing I am going to try is manually creating the insert sql commands and run these in EM, just a pita if I am missing something obvious. Interesting one. Graham _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/mn2pr10mb34074b10c9a34d95275996edd2...@mn2pr10mb3407.namprd10.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.