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 |
|
chetan_dba
Starting Member
21 Posts |
 Posted - 2008-04-03 : 03:40:33
|
| Hi ..This is chetan jain DBA sql server..i want to know that...1.can i move some tables of database through DTS to another server having refrential integrity ( source tables have refrential integrity)????Thanks in advance.-- Chetan |
|
|
pravin14u
Posting Yak Master
246 Posts |
Posted - 2008-04-03 : 04:14:34
|
| Can you give more details?You can move the data until your referential integrity in the destination tables are not being violated(since you are saying that the source systems have referential integrity, I assume the load would be fine using DTS)Prakash.PThe secret to creativity is knowing how to hide your sources! |
 |
|
|
chetan_dba
Starting Member
21 Posts |
Posted - 2008-04-03 : 05:22:54
|
| Hi,My Destination DB is empty..I have around 5-6 tables in Source DB which are having referential integrity.Question :1) What will be result if i want to move some of the those tables ? and also if the tables which i wanted to move are part of that referential intergrity ( means Table A is having Referential Integrity with Table B. I wanted to move only Table A).2) What if i want to move all the tables to Destination DB.2)Thanks in advance.-- Chetan |
|
|
|
pravin14u
Posting Yak Master
246 Posts |
Posted - 2008-04-03 : 05:39:50
|
quote:
Originally posted by chetan_dba
Hi,My Destination DB is empty..I have around 5-6 tables in Source DB which are having referential integrity.Question :1) What will be result if i want to move some of the those tables ? and also if the tables which i wanted to move are part of that referential intergrity ( means Table A is having Referential Integrity with Table B. I wanted to move only Table A).2) What if i want to move all the tables to Destination DB.Thanks in advance.-- Chetan
1) There wont be any issues. DTS just transfers DATA and not the constraints.2) All the tables will be moved but they wont have referential integrity defined among them.Prakash.PThe secret to creativity is knowing how to hide your sources! |
|
|
|
|
|
|
copy tables containing refrential integrity