Re: FW: SQL Upsize

; rk > > From: ProfoxTech 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

SQL Upsize

Hi Don't know if this upsize code will help anybody else but will share it. This has been run with SQL express 2008r2 Run the upsizing wizard to send the structure with no data. Run this on a backup of the fox data. This uses Pauls CABuilder to generate CursorAdapters for the SQL database It th

Re: FW: SQL Upsize

g and why. Just a thought. > > Paul H. Tarver > Tarver Program Consultants, Inc. > > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of > Graham Brown > Sent: Friday, October 06, 2023 3:11 AM > To: profoxt...@leafe.com > S

RE: FW: SQL Upsize

profoxtech-boun...@leafe.com] On Behalf Of Graham Brown Sent: Friday, October 06, 2023 3:11 AM To: profoxt...@leafe.com Subject: RE: FW: SQL Upsize Thanks What is Navicat? -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Virgil Bierschwale Sent: 05 October 2023 2

Re: FW: SQL Upsize

n...@leafe.com] On Behalf Of Virgil > Bierschwale > Sent: 06 October 2023 11:42 > To: ProFox Email List > Subject: Re: FW: SQL Upsize > > https://navicat.com/en/ > > > On Fri, Oct 6, 2023 at 3:11 AM Graham Brown wrote: > > > Thanks > > > > What is Navicat? &

RE: FW: SQL Upsize

Thanks. I'll take a look. -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Virgil Bierschwale Sent: 06 October 2023 11:42 To: ProFox Email List Subject: Re: FW: SQL Upsize https://navicat.com/en/ On Fri, Oct 6, 2023 at 3:11 AM Graham Brown

Re: FW: SQL Upsize

mail List > Subject: Re: FW: SQL Upsize > > I use navicat. > copy the dbf to csv or txt. > use navicat to connect to sql server. > and then do a import. > > I've added about 10GB data to mysql that way and it works pretty good. > they have a version for sql server as well

RE: FW: SQL Upsize

Thanks What is Navicat? -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Virgil Bierschwale Sent: 05 October 2023 20:04 To: ProFox Email List Subject: Re: FW: SQL Upsize I use navicat. copy the dbf to csv or txt. use navicat to connect to sql server. and

Re: FW: SQL Upsize

lto:profox-boun...@leafe.com] On Behalf Of Kurt Wendt > Sent: 05 October 2023 17:21 > To: ProFox Email List > Subject: Re: FW: SQL Upsize > > Hey there Graham, > > Now, I know this is going to be more of a WAG or a total Shot-in-the-Dark, > Butt... > > Also, I will

RE: FW: SQL Upsize

2008? Not so much... 😉 <https://github.com/VFPX/UpsizingWizard> -- rk From: ProfoxTech 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 wiz

RE: FW: SQL Upsize

List Subject: Re: FW: SQL Upsize Hey there Graham, Now, I know this is going to be more of a WAG or a total Shot-in-the-Dark, Butt... Also, I will admit - I am not familiar with the exact process you're attempting to do. I did try something similar MANY Years ago, admittedly - back in

Re: FW: SQL Upsize

Hey there Graham, Now, I know this is going to be more of a WAG or a total Shot-in-the-Dark, Butt... Also, I will admit - I am not familiar with the exact process you're attempting to do. I did try something similar MANY Years ago, admittedly - back in like 2012. Anyway... So, my question is thi

FW: SQL Upsize

Hi all I am upsizing a Foxpro DBC to SQL 2008 r2. This worked fine with earlier versions of SQL but gives errors to newer versions of SQL. I am using ODBC rather than Native client although it doesn't make any difference to the errors. For one specific table the upsize says 988 rows failed.