Web Wiz Support and Community Forums : DTS between 2 SQL servers https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Tue, 07 Apr 2026 02:31:31 +0000 Fri, 26 Dec 2003 09:04:55 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=8304 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[DTS between 2 SQL servers : Thank you for this. I knew &#034;enable...]]> https://forums.webwiz.net/dts-between-2-sql-servers_topic8304_post43139.html#43139 Author: ludovic
Subject: 8304
Posted: 26 December 2003 at 9:04am

Thank you for this.

I knew "enable Identity Insert" but I discover the problem of the right order. It's evident !  

]]> Fri, 26 Dec 2003 09:04:55 +0000 https://forums.webwiz.net/dts-between-2-sql-servers_topic8304_post43139.html#43139 <![CDATA[DTS between 2 SQL servers : You need to click on the Transform...]]> https://forums.webwiz.net/dts-between-2-sql-servers_topic8304_post43135.html#43135 Author: michael
Subject: 8304
Posted: 26 December 2003 at 8:49am

You need to click on the Transform button and enable Identity Insertfor that table, also make sure to import the tables in the right orderso there is no key violation i.e. if you import threads before authoresyou get a violation becuase the Author_ID does not exist for a threadyou are trying to import so will fail.]]> Fri, 26 Dec 2003 08:49:09 +0000 https://forums.webwiz.net/dts-between-2-sql-servers_topic8304_post43135.html#43135 <![CDATA[DTS between 2 SQL servers : When you copy from a distant server...]]> https://forums.webwiz.net/dts-between-2-sql-servers_topic8304_post43114.html#43114 Author: ludovic
Subject: 8304
Posted: 26 December 2003 at 2:54am

When you copy from a distant server to an other, the copy is impossible for the tables : Author, DateTimeFormat, Group, Guestname, Smut.

Error message for instance :

Error : Violation on Primary Key Constraint 'PK_tblAuthor_1D114BD1' Cannot insert duplicate key in object "tbl_Author"

Thanks for your help

]]> Fri, 26 Dec 2003 02:54:34 +0000 https://forums.webwiz.net/dts-between-2-sql-servers_topic8304_post43114.html#43114 <![CDATA[DTS between 2 SQL servers : IT works fine using DTS, you can...]]> https://forums.webwiz.net/dts-between-2-sql-servers_topic8304_post42875.html#42875 Author: michael
Subject: 8304
Posted: 23 December 2003 at 12:26pm

IT works fine using DTS, you can add rows to existing or overwrite existing, if you give us some more detail on what the problem is, maybe we can help.]]> Tue, 23 Dec 2003 12:26:58 +0000 https://forums.webwiz.net/dts-between-2-sql-servers_topic8304_post42875.html#42875 <![CDATA[DTS between 2 SQL servers : Why a simple DTS doesn&#039;t...]]> https://forums.webwiz.net/dts-between-2-sql-servers_topic8304_post42869.html#42869 Author: ludovic
Subject: 8304
Posted: 23 December 2003 at 11:44am

Why a simple DTS doesn't work to migrate tables from a server to another ?

How can you do this without doing a global import ??

Thanks a lot for your answers.

 

]]> Tue, 23 Dec 2003 11:44:26 +0000 https://forums.webwiz.net/dts-between-2-sql-servers_topic8304_post42869.html#42869