Copying Data From One DataBase To Another?

Yet another very much newbie question I suspect….

I want to know how I copy data from one field in one

DataBase to another field in another DataBase?

Basically I have an ASP driven forum, and want to upgrade to

a new ASP.NET forum… Problem is obviously the DataBase structure is different

and I don’t want to loose all the data from my current forum…So I would have to pick which table field

needs to be copied to where in the new DataBase..

Is this easy to do?

I will be using SQLExpress 2005?

Thanks

You can use a statement with a three-part name:

INSERT INTO YourTable
( ColumnsHere)
SELECT ColumnsFromtheOtherDb here
FROM Databasename.SchemaName.TableName

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de