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-10 : 07:22:37
|
| Daryl writes "This is the situation:- A NEW database is replicated from an OLD database- More columns are added into NEW in different tablesIs there a way to append data from the OLD to the NEW database?(As in dbase, it is just a simple APPEND statement, all the columns that does not exist will be blank)." |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2003-03-10 : 09:01:32
|
| You can use the Data Transformation Services (DTS) to do this. See BOL or a good bookOr bcp (bulk copy program) i believe===========Paul |
 |
|
|
|
|
|
Import from a database with fewer columns in table