copy table to one database to onther

  • Thread starter Thread starter Neeraj
  • Start date Start date
N

Neeraj

hi
I want to create a table in a database with same schema and data of
other database.
what i am doing is i make a connection to second database make a
select statement "SELECT * FROM modul"
DataTable dt = ds.Tables[0].Copy();
now i get DataTable then how can i save it to another database with
same table Name.
thanks
Neeraj Kumar
 
Neeraj,

What kind of database servers are these? Are they both SQL Server? If
so, why not run a Data Transformation Service (DTS) package to do this?
It's MUCH easier and much quicker.
 
Thanks Nichola

we are going to implement caching of of server database to locally.
i have to write C# code so that i can create some table of the
databse. in locaclly.
but i am not able to get exact datatype in c# as SQL Server.
so how can i approach this please guid me
Thanks
Neeraj
 
Back
Top