• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 661
  • Last Modified:

Dbf 2 MySql table

I need to move fields from a dbf table to MySql for use on my server.

Any suggestions ?

Please codes or freeware components .
0
ginsonic
Asked:
ginsonic
  • 8
  • 3
  • 2
  • +2
1 Solution
 
kretzschmarCommented:
a tbatchmove-component,
two aliases pointed to the different databases

is needed, and a bit code,
thats all


meikl ;-)
0
 
ginsonicAuthor Commented:
Can you help me with a sample project ?
0
 
marcoszorrillaCommented:
Perhaps a bit of SQL:

Select MyTableDbf.* INTO MyNewTable
FROM MyTableDbf;

Best Regards.
Marcos.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
ginsonicAuthor Commented:
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
 
ginsonicAuthor Commented:
Dbf                            MySql
Field1                        Field1
Field2+' '+
Field3+' '+
Field4                        Field2  
0
 
ginsonicAuthor Commented:
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
 
kretzschmarCommented:
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
 
ginsonicAuthor Commented:
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
 
kretzschmarCommented:
insert into ::mySQL_alias::nuke_encyclopedia_text (title,text) select name, width||genre from ::dbf_alias::dbf_tablename
0
 
_MeSSiah_Commented:
I'm working on the sample application ...
0
 
ginsonicAuthor Commented:
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
 
ginsonicAuthor Commented:
MeSSiah_ , any news there ?
0
 
ginsonicAuthor Commented:
I will ask to delete this question
0
 
MindphaserCommented:
ginsonic asked to have this question closed. If there are no objections I will

  PAQ and refund the points

in 72 hours.
0
 
MindphaserCommented:
Points refunded and moved to PAQ

** Mindphaser - Community Support Moderator **
0

Featured Post

Industry Leaders: 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!

  • 8
  • 3
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now