Print Page | Close Window

DTS between 2 SQL servers

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=8304
Printed Date: 07 April 2026 at 2:30am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: DTS between 2 SQL servers
Posted By: ludovic
Subject: DTS between 2 SQL servers
Date 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.

 




Replies:
Posted By: michael
Date 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.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker


Posted By: ludovic
Date 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



Posted By: michael
Date Posted: 26 December 2003 at 8:49am
You need to click on the Transform button and enable Identity Insert for that table, also make sure to import the tables in the right order so there is no key violation i.e. if you import threads before authores you get a violation becuase the Author_ID does not exist for a thread you are trying to import so will fail.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker


Posted By: ludovic
Date 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 !  




Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net