?
Solved

Dbf 2 MySql table

Posted on 2002-07-15
15
Medium Priority
?
657 Views
Last Modified: 2010-04-04
I need to move fields from a dbf table to MySql for use on my server.

Any suggestions ?

Please codes or freeware components .
0
Comment
Question by:ginsonic
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 3
  • 2
  • +2
15 Comments
 
LVL 27

Expert Comment

by:kretzschmar
ID: 7155264
a tbatchmove-component,
two aliases pointed to the different databases

is needed, and a bit code,
thats all


meikl ;-)
0
 
LVL 9

Author Comment

by:ginsonic
ID: 7155374
Can you help me with a sample project ?
0
 
LVL 3

Expert Comment

by:marcoszorrilla
ID: 7155563
Perhaps a bit of SQL:

Select MyTableDbf.* INTO MyNewTable
FROM MyTableDbf;

Best Regards.
Marcos.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 9

Author Comment

by:ginsonic
ID: 7156182
I don't wish to make a sql copy of my dbf table.
I just wish to copy one field into another MySqol field and all others left fields from dbf into a single MySql field.

Dbf          MySql
Field1       Field1
Field2+' '+
Field3+' '+
Field4       Field2  
0
 
LVL 9

Author Comment

by:ginsonic
ID: 7156186
Dbf                            MySql
Field1                        Field1
Field2+' '+
Field3+' '+
Field4                        Field2  
0
 
LVL 9

Author Comment

by:ginsonic
ID: 7156222
I found next link for this conversion:
http://ae.inc.ru/dbf2mysql_src.php3

But I need just couple line to copy a field into MySql first field and others fields into the second MySql field.

300 points for this.
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 7156327
with local-sql

for create

create ::mySQL_Alias::tablename
as
select fieldname1||fieldname2, MaybeMoreFields
from ::dbf_alias::tablename

for copy

insert into ::mySQL_Alias::tablename (MayBeFieldList)
select fieldname1||fieldname2, MaybeMoreFields
from ::dbf_alias::tablename

meikl ;-)
0
 
LVL 9

Author Comment

by:ginsonic
ID: 7156902
I still don't understand how to do that.

I have next MySql structure table :

CREATE TABLE nuke_encyclopedia_text (
  tid int(10) NOT NULL auto_increment,
  eid int(10) NOT NULL default '0',
  title varchar(255) NOT NULL default '',
  text text NOT NULL,
  counter int(10) NOT NULL default '0',
  PRIMARY KEY  (tid)
) TYPE=MyISAM;

In dbf I have next fields: 'Name', 'Width','Genre'( just for example ).

I wish to store name into title field and 'Width'+'Genre' into text field.


Increased to 300 points for working sample.
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 7156911
insert into ::mySQL_alias::nuke_encyclopedia_text (title,text) select name, width||genre from ::dbf_alias::dbf_tablename
0
 
LVL 1

Expert Comment

by:_MeSSiah_
ID: 7157567
I'm working on the sample application ...
0
 
LVL 9

Author Comment

by:ginsonic
ID: 7158660
Wait then :)

Untill then I copy my dbf into a new dbf table where the fields use my rules and then with dbf2mysql program I convert the table.

But I still preffer a proffesional way ( a directly conversion ).
0
 
LVL 9

Author Comment

by:ginsonic
ID: 7176327
MeSSiah_ , any news there ?
0
 
LVL 9

Author Comment

by:ginsonic
ID: 7808865
I will ask to delete this question
0
 
LVL 6

Expert Comment

by:Mindphaser
ID: 7919859
ginsonic asked to have this question closed. If there are no objections I will

  PAQ and refund the points

in 72 hours.
0
 
LVL 6

Accepted Solution

by:
Mindphaser earned 0 total points
ID: 7942416
Points refunded and moved to PAQ

** Mindphaser - Community Support Moderator **
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses
Course of the Month11 days, 17 hours left to enroll

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question