Re: Data transfer..... (walkthroughs ?)

paulizaz — Thu, 26 Apr 2007 15:47:59 GMT

Thanks,

But is this suitable for a complete site migration?

From one SQL database to another where the fields may differ slightly.

Regards,

Re: Data transfer..... (walkthroughs ?)

Benson Yu - MSFT — Fri, 13 Apr 2007 02:29:41 GMT

Hi paulizaz,

SQL Server provides the import/export tool to let us copy and transfer data easily. I recommend you to use it.

We can write our own class to do that, but I think it cannot as efficient and powerful as the tool SQL Server provided.

In my opinion, firstly we shall get the table schema from the table in old database and create the same or similar table in new database. Secondly we read the data from old table to a in memory DataTable object. At last, insert all the rows from DataTable to the table in new database.

Here are some links helpful for this scenario:

http://support.microsoft.com/kb/310107

http://msdn2.microsoft.com/en-us/library/fksx3b4f(VS.80).aspx

About how to insert all the data from DataTable to database table, here is a sample:

foreach (TableRow row in table.Rows)

{

command.CommandText = String.Format("INSERT INTO table VALUES ( {0},{1})", row[0], row[1]);

connection.Open();

command.ExecuteNonQuery();

connection.Close();

}

Data transfer..... (walkthroughs ?)

paulizaz — Wed, 11 Apr 2007 10:24:20 GMT

Hello,

I am asked to write a C# class that maps data from an old database to another database on a new server.

Is there a walkthrough to help me?, does anyone know of any other resources?

Any help appreciated..........

Visual Studio 2005

Re: Data transfer..... (walkthroughs ?)

Re: Data transfer..... (walkthroughs ?)

Data transfer..... (walkthroughs ?)