It may be an issue with a date column in FP that is not the same thing in newer versions of SQL Server.
It may be a lot of other things as well, this is first guess. How many gigs of data? What version of SQL are you targeting? Are you using SSMS to work with SQL? With that you could PULL the data from FoxPro into a new db that you create. I think the oledb driver will still be seen and useable in SSMS? On Thu, Oct 5, 2023 at 12:18 PM Richard Kaye <rk...@invaluable.com> wrote: > 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 > [excessive quoting removed by server] _______________________________________________ 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/cajidmyjlp0arvx4-8qgdeyrqgk-zhbrmz0m7q6kubenp-ge...@mail.gmail.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.
