Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-03-27 : 07:46:07
|
| Kapil writes "I want to transfer the data only from one database to another database.The second database has a schema modified.For example a new column(allow nulls) has been introduced in the existing table of the first schema.For example Ist Database schema has a table Employee with fields ( empid,empname)In the IInd Database schema we have added a new column in Employee tableEmployee with fields(empid,empname,address)address can allow nullsWe want to transfer all the data which is present in Ist database schema table Employee to IInd database schema table Employee(address can be blank for existing data)How to do this? Is there any limitation that the data can only be transfered between the tables with exactly the same schema. Please respond soon.I am using MS SQL Server 7.0" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-03-27 : 08:56:46
|
| Should be no probleminsert IInd.dbo.employee (empid, empname)select empid, empname from Ist.dbo.employeeJay White{0} |
 |
|
|
|
|
|
Problem with Import/Export of DATA only