Converting Database Schema

[Islamegy]

In my C# project..
I have Sql Database with data of 700 MB... I'm redesign tables and
relations and need to retrieve my data in the new tables..

I'm using SqlAdapter to Get old tables in my dataset then use the
GetChildRows(). .. insert new records in the new tables.
Here is the code which convert first 2 tables to 3 new tables:-

####### CODE START ############### ########
private void btn_Start_Click (object sender, System.EventArg s e)

{

this.transActio nStart();

}

private void transActionStar t()

{

progressBar1.Va lue = 0;

adp_Old_E7sea2y a.Fill(dsOld.E7 saeya_List);

adp_Old_Country _list.Fill(dsOl d.E7saeya_Count ry_List);

adp_Old_Mo2shra t.Fill(dsOld.E7 saeyaDetails);

adp_Old_Mo2_Det ails.Fill(dsOld .E7saeya_Main);

progressBar1.Ma ximum = dsOld.E7saeya_L ist.Rows.Count;

this.setAhsa2ya t();

}

private void setAhsa2yat()

{

ni_Ahsa2yat = new NewIndex();

foreach (DataSetOld.E7s aeya_ListRow row in dsOld.E7saeya_L ist)

{

int ah_id = ni_Ahsa2yat.Get Index("Ahsa2yat ");

int succ = this.sqlCommand Param(Ins_Ahsa2 ya, ah_id, row.E7saeya_Nam e);

if (succ == 1)

{

ni_Ahsa2yat.Upd ateIndex("Ahsa2 yat");

DataSetOld.E7sa eya_Country_Lis tRow[] rows=
(DataSetOld.E7s aeya_Country_Li stRow[])row.GetChildRo ws("Rel_AH_Coun try");

this.setCountri es(rows, row.E7saeya_ID, ah_id);

}
System.Threadin g.Thread.Sleep( 1);

progressBar1.Va lue += 1;

}

Conn.Close();

}
private void setCountries(Da taSetOld.E7saey a_Country_ListR ow[]
e7saeya_Country _ListRows, int old_E7sa2ya_ID, int new_A7sa2ya_ID)

{

ni_Country = new NewIndex();

foreach (DataSetOld.E7s aeya_Country_Li stRow row in e7saeya_Country _ListRows)

{

DataSetOld.E7sa eyaDetailsRow[] rows =
(DataSetOld.E7s aeyaDetailsRow[])row.GetChildRo ws("Rel_Country _Mo2");
int country_id = ni_Ahsa2yat.Get Index("Country" );

int sucess =
this.sqlCommand Param(Ins_Count ry,country_id,r ow.E7saeya_Coun try_Name);

if(sucess == 1)

{

ni_Country.Upda teIndex("Countr y");

this.setAHCount ry(rows, row.E7saeya_Cou ntry_ID, new_A7sa2ya_ID, country_id);

}

else

{

SelCountryID.Pa rameters["@NAME"].Value = row.E7saeya_Cou ntry_Name;

int exist_id = (int)SelCountry ID.ExecuteScala r();

this.setAHCount ry(rows, row.E7saeya_Cou ntry_ID, new_A7sa2ya_ID, exist_id);

}

}

}
private void setAHCountry(Da taSetOld.E7saey aDetailsRow[] e7saeyaDetailsR ows,
int old_AH_Country_ ID, int new_A7sa2ya_ID, int new_country_id)

{

ni_Ah_Country = new NewIndex();

int ah_country_id = ni_Ah_Country.G etIndex("Ahsa2_ Country");

int success =
this.sqlCommand Param(Ins_AhCou ntry,ah_country _id,new_A7sa2ya _ID,new_country _
id);

if(success == 1)

{

ni_Ah_Country.U pdateIndex("Ahs a2_Country");

setMo2shrat(e7s aeyaDetailsRows , old_AH_Country_ ID, ah_country_id);

}

}

############### # CODE END ############### #####

My Company was using Delphi and I'm megrate everything to C#.. My way work
well but take to much time and memory, The old Delphi Code was doing this
task in 20% of the time and don't use so much system resources like mine?!

Is there better way to copy my data with the new shcema??

thanx