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 |
|
mattbing
Starting Member
3 Posts |
 Posted - 2002-04-04 : 08:47:03
|
| I was wondering if there is a way to not only copy the data of a table, but the schema of the table as well? I have a main server that needs to DTS data to a number of other machines and I would like to add fields to the table and propogate those changes to the other servers. Is there a way to do this in a dts package or will I have to hit every server and make the change??? Thanks in advanceMatt |
|
|
Jay99
468 Posts |
Posted - 2002-04-04 : 09:10:05
|
| If you are running SQL 2k, take a look at the Copy SQL Objects Task (or whatever it is called, I don't have it infront of me) or replication (non-DTS Solution).If you are running SQL 7 or 6.5 take a look at replication (non-DTS Solution).Jay<O> |
 |
|
|
mattbing
Starting Member
3 Posts |
Posted - 2002-04-04 : 09:19:03
|
quote:
If you are running SQL 2k, take a look at the Copy SQL Objects Task (or whatever it is called, I don't have it infront of me) or replication (non-DTS Solution).If you are running SQL 7 or 6.5 take a look at replication (non-DTS Solution).Jay<O>
JayThanks for the prompt reply - I have looked at the copy sql objects and I tried just copying the object - no data or anything and nothing happened. I tried copying data and even recreating, those two tries failed. |
|
|
|
Jay99
468 Posts |
Posted - 2002-04-04 : 09:38:39
|
| Like I said I don't have 2k infront of me. I would re-read the help section on the task and make sure you've got it set up correctly. I have used the task many times to do exactly what you are talking about.Jay<O> |
|
|
|
mattbing
Starting Member
3 Posts |
Posted - 2002-04-04 : 09:48:55
|
quote:
Like I said I don't have 2k infront of me. I would re-read the help section on the task and make sure you've got it set up correctly. I have used the task many times to do exactly what you are talking about.Jay<O>
I will do that - thanks for the advice |
|
|
|
|
|
|
Table Schema in DTS