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. Only a few records show an error in the report (6) and this is connectivity error failed to convert numeric to float. The destination fields do not show float so not sure what it is complaining about.
Has anyone seen the same please.
Regards
Graham
Ps Sent the last one to owner@, sorry Ed.
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
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 this - did your Process at least create the Database files in SQL - and SOME of the records did make it into the Database? If so, why not push the records into SQL Databases from FoxPro after the SQL databases were already created?
Now, I know - it's Not Addressing your original problem. But, I figured I would throw some suggestions out there...
-Kurt
On Thu, Oct 5, 2023 at 8:44 AM Graham Brown gbrown@compsys.co.uk wrote:
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. Only a few records show an error in the report (6) and this is connectivity error failed to convert numeric to float. The destination fields do not show float so not sure what it is complaining about.
Has anyone seen the same please.
Regards
Graham
Ps Sent the last one to owner@, sorry Ed.
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
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
-----Original Message----- From: ProFox [mailto:profox-bounces@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 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 this - did your Process at least create the Database files in SQL - and SOME of the records did make it into the Database? If so, why not push the records into SQL Databases from FoxPro after the SQL databases were already created?
Now, I know - it's Not Addressing your original problem. But, I figured I would throw some suggestions out there...
-Kurt
On Thu, Oct 5, 2023 at 8:44 AM Graham Brown gbrown@compsys.co.uk wrote:
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. Only a few records show an error in the report (6) and this is connectivity error failed to convert numeric to float. The destination fields do not show float so not sure what it is complaining about.
Has anyone seen the same please.
Regards
Graham
Ps Sent the last one to owner@, sorry Ed.
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
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-bounces@leafe.com On Behalf Of Graham Brown Sent: Thursday, October 5, 2023 12:35 PM To: profoxtech@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
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 rkaye@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-bounces@leafe.com On Behalf Of Graham Brown Sent: Thursday, October 5, 2023 12:35 PM To: profoxtech@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]
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.
On Thu, Oct 5, 2023 at 11:36 AM Graham Brown gbrown@compsys.co.uk wrote:
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
-----Original Message----- From: ProFox [mailto:profox-bounces@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 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 this - did your Process at least create the Database files in SQL - and SOME of the records did make it into the Database? If so, why not push the records into SQL Databases from FoxPro after the SQL databases were already created?
Now, I know - it's Not Addressing your original problem. But, I figured I would throw some suggestions out there...
-Kurt
On Thu, Oct 5, 2023 at 8:44 AM Graham Brown gbrown@compsys.co.uk wrote:
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. Only a few
records
show an error in the report (6) and this is connectivity error failed to convert numeric to float. The destination fields do not show float so not sure what it is complaining about.
Has anyone seen the same please.
Regards
Graham
Ps Sent the last one to owner@, sorry Ed.
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
Thanks
What is Navicat?
-----Original Message----- From: ProFox [mailto:profox-bounces@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 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.
On Thu, Oct 5, 2023 at 11:36 AM Graham Brown gbrown@compsys.co.uk wrote:
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
-----Original Message----- From: ProFox [mailto:profox-bounces@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 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 this - did your Process at least create the Database files in SQL - and SOME of the records did make it into the Database? If so, why not push the records into SQL Databases from FoxPro after the SQL databases were already created?
Now, I know - it's Not Addressing your original problem. But, I figured I would throw some suggestions out there...
-Kurt
On Thu, Oct 5, 2023 at 8:44 AM Graham Brown gbrown@compsys.co.uk wrote:
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. Only a few
records
show an error in the report (6) and this is connectivity error failed to convert numeric to float. The destination fields do not show float so not sure what it is complaining about.
Has anyone seen the same please.
Regards
Graham
Ps Sent the last one to owner@, sorry Ed.
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
On Fri, Oct 6, 2023 at 3:11 AM Graham Brown gbrown@compsys.co.uk wrote:
Thanks
What is Navicat?
-----Original Message----- From: ProFox [mailto:profox-bounces@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 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.
On Thu, Oct 5, 2023 at 11:36 AM Graham Brown gbrown@compsys.co.uk wrote:
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
-----Original Message----- From: ProFox [mailto:profox-bounces@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 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 this - did your Process at least create the Database files in SQL - and SOME of the records did make it into the Database? If so, why not push the records into SQL Databases from FoxPro after the SQL databases were already created?
Now, I know - it's Not Addressing your original problem. But, I figured I would throw some suggestions out there...
-Kurt
On Thu, Oct 5, 2023 at 8:44 AM Graham Brown gbrown@compsys.co.uk
wrote:
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. Only a few
records
show an error in the report (6) and this is connectivity error failed
to
convert numeric to float. The destination fields do not show float so
not
sure what it is complaining about.
Has anyone seen the same please.
Regards
Graham
Ps Sent the last one to owner@, sorry Ed.
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
Thanks. I'll take a look.
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Virgil Bierschwale Sent: 06 October 2023 11:42 To: ProFox Email List Subject: Re: FW: SQL Upsize
On Fri, Oct 6, 2023 at 3:11 AM Graham Brown gbrown@compsys.co.uk wrote:
Thanks
What is Navicat?
-----Original Message----- From: ProFox [mailto:profox-bounces@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 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.
On Thu, Oct 5, 2023 at 11:36 AM Graham Brown gbrown@compsys.co.uk wrote:
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
-----Original Message----- From: ProFox [mailto:profox-bounces@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 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 this - did your Process at least create the Database files in SQL - and SOME of the records did make it into the Database? If so, why not push the records into SQL Databases from FoxPro after the SQL databases were already created?
Now, I know - it's Not Addressing your original problem. But, I figured I would throw some suggestions out there...
-Kurt
On Thu, Oct 5, 2023 at 8:44 AM Graham Brown gbrown@compsys.co.uk
wrote:
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. Only a few
records
show an error in the report (6) and this is connectivity error failed
to
convert numeric to float. The destination fields do not show float so
not
sure what it is complaining about.
Has anyone seen the same please.
Regards
Graham
Ps Sent the last one to owner@, sorry Ed.
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
When I first started decades ago, I would attempt to use phpmyadmin to import 600,000 plus record tables and it would always break. Once I finally realized that it was a problem with phpmyadmin and started using navicat, haven't had a problem since.
It's basically like the sql server administrator. I believe you can do the same with sql server administrator but its been a long time since I've used it.
On Fri, Oct 6, 2023 at 9:23 AM Graham Brown gbrown@compsys.co.uk wrote:
Thanks. I'll take a look.
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Virgil Bierschwale Sent: 06 October 2023 11:42 To: ProFox Email List Subject: Re: FW: SQL Upsize
On Fri, Oct 6, 2023 at 3:11 AM Graham Brown gbrown@compsys.co.uk wrote:
Thanks
What is Navicat?
-----Original Message----- From: ProFox [mailto:profox-bounces@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 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.
On Thu, Oct 5, 2023 at 11:36 AM Graham Brown gbrown@compsys.co.uk
wrote:
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
-----Original Message----- From: ProFox [mailto:profox-bounces@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 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 this - did your Process at least create the Database files in SQL - and SOME of the records did make it into the Database?
If
so, why not push the records into SQL Databases from FoxPro after the
SQL
databases were already created?
Now, I know - it's Not Addressing your original problem. But, I
figured I
would throw some suggestions out there...
-Kurt
On Thu, Oct 5, 2023 at 8:44 AM Graham Brown gbrown@compsys.co.uk
wrote:
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. Only a few
records
show an error in the report (6) and this is connectivity error failed
to
convert numeric to float. The destination fields do not show float so
not
sure what it is complaining about.
Has anyone seen the same please.
Regards
Graham
Ps Sent the last one to owner@, sorry Ed.
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
I wondered the same thing, but when I checked it out, I found that is a slightly pricier version of the SQL management tool I use which is from EMS Software Management. I think both Navicat and the EMS solutions occupy the same space and appear to offer the same features but I've been using EMS SQL Manager for a many years and it works pretty well for me. I don't recall trying to upsize any VFP database with it, but I know you can run .SQL scripts to create tables and populate them pretty easily. It's also very easy to export data to Excel or other data tools (which is what I use most of the time).
You can purchase everything ala carte which appears similar to the pricing model that Navicat uses but it looks like the support renewal is a little cheaper with EMS. I think I pay about $150 per year for support on the SQL Manager tool.
Anyway, not trying to hijack the thread with a discussion about different SQL Manager tools, but perhaps that would be a good NF topic to ask what external database tools everyone is using and why. Just a thought.
Paul H. Tarver Tarver Program Consultants, Inc.
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Graham Brown Sent: Friday, October 06, 2023 3:11 AM To: profoxtech@leafe.com Subject: RE: FW: SQL Upsize
Thanks
What is Navicat?
-----Original Message----- From: ProFox [mailto:profox-bounces@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 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.
On Thu, Oct 5, 2023 at 11:36 AM Graham Brown gbrown@compsys.co.uk wrote:
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
-----Original Message----- From: ProFox [mailto:profox-bounces@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 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 this - did your Process at least create the Database files in SQL - and SOME of the records did make it into the Database? If so, why not push the records into SQL Databases from FoxPro after the SQL databases were already created?
Now, I know - it's Not Addressing your original problem. But, I figured I would throw some suggestions out there...
-Kurt
On Thu, Oct 5, 2023 at 8:44 AM Graham Brown gbrown@compsys.co.uk wrote:
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. Only a few
records
show an error in the report (6) and this is connectivity error failed to convert numeric to float. The destination fields do not show float so not sure what it is complaining about.
Has anyone seen the same please.
Regards
Graham
Ps Sent the last one to owner@, sorry Ed.
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
agreed. being another destitute foxpro guy, I just purchased the one license and have never updated it. I don't think it could be used to convert the dbc. I would take the individual tables that are in the dbc and import them. but I mainly do php/mysql these days so its a different environment.
On Fri, Oct 6, 2023 at 10:20 AM Paul H. Tarver paul@tpcqpc.com wrote:
I wondered the same thing, but when I checked it out, I found that is a slightly pricier version of the SQL management tool I use which is from EMS Software Management. I think both Navicat and the EMS solutions occupy the same space and appear to offer the same features but I've been using EMS SQL Manager for a many years and it works pretty well for me. I don't recall trying to upsize any VFP database with it, but I know you can run .SQL scripts to create tables and populate them pretty easily. It's also very easy to export data to Excel or other data tools (which is what I use most of the time).
You can purchase everything ala carte which appears similar to the pricing model that Navicat uses but it looks like the support renewal is a little cheaper with EMS. I think I pay about $150 per year for support on the SQL Manager tool.
Anyway, not trying to hijack the thread with a discussion about different SQL Manager tools, but perhaps that would be a good NF topic to ask what external database tools everyone is using and why. Just a thought.
Paul H. Tarver Tarver Program Consultants, Inc.
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Graham Brown Sent: Friday, October 06, 2023 3:11 AM To: profoxtech@leafe.com Subject: RE: FW: SQL Upsize
Thanks
What is Navicat?
-----Original Message----- From: ProFox [mailto:profox-bounces@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 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.
On Thu, Oct 5, 2023 at 11:36 AM Graham Brown gbrown@compsys.co.uk wrote:
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
-----Original Message----- From: ProFox [mailto:profox-bounces@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 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 this - did your Process at least create the Database files in SQL - and SOME of the records did make it into the Database? If so, why not push the records into SQL Databases from FoxPro after the SQL databases were already created?
Now, I know - it's Not Addressing your original problem. But, I figured I would throw some suggestions out there...
-Kurt
On Thu, Oct 5, 2023 at 8:44 AM Graham Brown gbrown@compsys.co.uk
wrote:
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. Only a few
records
show an error in the report (6) and this is connectivity error failed
to
convert numeric to float. The destination fields do not show float so
not
sure what it is complaining about.
Has anyone seen the same please.
Regards
Graham
Ps Sent the last one to owner@, sorry Ed.
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
-
Graham Brown -
Kurt Wendt -
Paul H. Tarver -
Richard Kaye -
Stephen Russell -
Virgil Bierschwale