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
