hello,
i must convert a foxpro database tro a sql-server datase, and while
i'm thinking on it, are there any known programs??? maybe open source?
that do this job ??? because re-inventing the wheel is not that smart.
or if there isn't any, what driver should i use ???
thanks
5  5864 
foxpro has this built right in - database upsizing wizard
"drgonzo120 " <dr********@yah oo.comwrote in message
news:11******** **************@ v33g2000cwv.goo glegroups.com.. .
hello,
i must convert a foxpro database tro a sql-server datase, and while
i'm thinking on it, are there any known programs??? maybe open source?
that do this job ??? because re-inventing the wheel is not that smart.
or if there isn't any, what driver should i use ???
thanks
hello, i asked what version it was, and it still was an MS-DOS version
of foxpro, with 15 years of data in it ...
so this shakes the cards whole differently ...
can you export to the database to a textfile ??? (and then import it
manually)
any suggestions ???
In article <11************ **********@v33g 2000cwv.googleg roups.com>, dr********@yaho o.com says...
hello,
i must convert a foxpro database tro a sql-server datase, and while
i'm thinking on it, are there any known programs??? maybe open source?
that do this job ??? because re-inventing the wheel is not that smart.
or if there isn't any, what driver should i use ???
About 4 years ago, I remember using SQL DTS to convert (or "import" I
should say) an Access database into SQL Server. The DTS wizard had all
sorts of connection options for the "source" database and I think Foxpro
was listed. Take a look at DTS (Data Transformation Services).
--
Patrick Steele http://weblogs.asp.net/psteele
Hi,
"drgonzo120 " <dr********@yah oo.comwrote in message
news:11******** **************@ v33g2000cwv.goo glegroups.com.. .
| hello,
|
|
| i must convert a foxpro database tro a sql-server datase, and while
| i'm thinking on it, are there any known programs??? maybe open source?
| that do this job ??? because re-inventing the wheel is not that smart.
| or if there isn't any, what driver should i use ???
You can migrate the DB without problem, just use Import from the SQL
management console.
The code for using the DB is another matter, you would have to create the
front-end
--
Ignacio Machin
machin AT laceupsolutions com
Hi !
Others have suggested SQL Server DTS or the import wizard. To use it you'll
do best with the FoxPro and Visual FoxPro OLE DB data provider, downloadable
from the link below my signature. It works with all versions of Fox tables
including FoxPro for DOS.
As Ignacio said, you'll still need a front end for the data, which could be
written in MS Visual FoxPro, MS Access, MS VB.NET or C#.NET, or a web front
end.
--
Cindy Winegarden ci***@cindywine garden.com
VFP OLE DB: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx
VFP ODBC: http://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx
"drgonzo120 " <dr********@yah oo.comwrote in message
news:11******** **************@ v33g2000cwv.goo glegroups.com.. .
hello,
i must convert a foxpro database tro a sql-server datase, and while
i'm thinking on it, are there any known programs??? maybe open source?
that do this job ??? because re-inventing the wheel is not that smart.
or if there isn't any, what driver should i use ???
thanks
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Matt Young |
last post by:
I've been tasked with integrating an older management system based on
DBF files with my snappy new ASP application to provide users of the
ASP application with real-time data from the management system.
I figure with DBF files, I should use either the DBase drivers or the
FoxPro drivers to connect to the database.
The integration has gone quite smoothly until yesterday. This means
that my connection strings work well based on the...
|
by: Simon Bailey |
last post by:
I am a newcomer to databases and am not sure which DBMS to use. I have
a very simplified knowledge of databases overall. I would very much
appreciate a (simplifed) message explaining the advantages and
disadvantages of both programs.
Many Thanks
Simon
|
by: Alfred |
last post by:
Hi
What is the difference between Access and Foxpro and who will use Foxpro.
Thanks Alfred
|
by: M S Baker |
last post by:
Is there any way to create a query similar to the old CASE statement in
FoxPro?
|
by: Maverick |
last post by:
If i try to create foxpro table by the following "sql" statment, the C#
compiler will only return an error "xxxx not support in non-dbc version". The
"index on" command statement return some kind of syntex error too. How can i
create a DBF table with proper indexing ability ?? The "UNIQUE" keyword has
already been proved to be failed to perform normally. Please help
string sql = "CREATE TABLE datafile (field1 C(10) PRIMARY KEY, field2...
| | |
by: Sascha Schmidt |
last post by:
Hello !
I have a little problem accessing a Visual Foxpro-database using ODBC (Driver 6.00.8167)
(using System.Data.Odbc). Reading a column, defined in the Foxpro table definition as a kind
of binary char (i'm no foxpro-expert and the database is predetermined) and containing
Unicode-String, delivers a byte structure in the resulting DataSet. Showing
this column in a Datagrid only results in displaying "byte" instead of a value.
Now...
|
by: DKode |
last post by:
Hello,
I am creating a data layer that will handle SQL(SQLClient) and Visual
Foxpro (OleDb). The way I am thinking about creating it is create a
base class that handles setting of connectionstring and accessors for
IDbAdapter, IDbCommand, IDbConnection etc..
then in the derived classes I handle casting the connection/commands to
the proper type and return results.
|
by: vj |
last post by:
Please let me know , what are the various impacts on migrating UDB DB2
8.1 to Mainframes.
Thanks
Vijay.T
|
by: Robert Hooker |
last post by:
I have installed our .NET application on a system running Microsoft Windows
Vista operating system.
When I run our application, I receive the following error message whenever
it tries to create a DBF file using VFPODBC:
"ERROR Driver does not support this
function"
I am using a connection string that I have used for many years with no
problems, here is some sample C# code:
|
by: HistoricVFP |
last post by:
Hello,
I’ve been given the task of importing .dbf files from a very old version of Visual FoxPro (version 2.1) into Access (2003). When I import the data straight to Access it errors with:
External table is not in the expected format. (Error 3274)
I’ve tried the following but it did not work:
“To import data from a FoxPro database, use the Microsoft Visual FoxPro ODBC driver. To do so, follow these steps:
1. Click Start, and then...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
