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 - 2002-09-25 : 09:31:49
|
| Phil writes "Hi,I'm trying to DTS tables, data, foreign keys, etc. over from one database to another. One of the database has replication running on it. I don't want any of the replication stuff getting over in my DTS package. Is there a way to DTS just the tables and data w/out getting all the replication stuff?Thanks,Phil" |
|
|
tacket
Starting Member
47 Posts |
Posted - 2002-09-25 : 13:30:02
|
| Hi, Phil here again,I noticed that next to the database is an advanced connection properties button. When I click in there I see something about replication server name connect option. Is this where I can turn off replication from coming over in a dts package? I'm not finding very much in SQL Books online for this issue.Thanks,Phil |
 |
|
|
Tim
Starting Member
392 Posts |
Posted - 2002-09-25 : 20:27:31
|
| I don't know how to stop the replication objects coming over, but it would be easy to add a "cleanup" step to your DTS package. The ExecSQL task could be used to call the sp_removedbreplication stored procedure. That will get rid of the replication objects for you.----Nancy Davolio: Best looking chick at Northwind 1992-2000 |
|
|
|
tacket
Starting Member
47 Posts |
Posted - 2002-09-27 : 11:47:28
|
| Can sp_removedbreplication be targeted to a specific replication schema? Let's say that I already had some replication running on the server I'm copying to and I want to delete the replication coming over, (after the fact) with this sp_removedbreplication SQL stored procedure. Can this be done?BTW thanks for the answer Tim. |
|
|
|
|
|
|
DTS and not get the replication stuff