DTS between 2 SQL servers

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
ludovic Members Profile Find Members Posts Newbie Joined: 23 December 2003 Status: Offline Points: 3	Post Options Post Reply Quote ludovic Report Post Thanks(0) Quote Reply Topic: DTS between 2 SQL servers 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.

michael Members Profile Find Members Posts Senior Member Joined: 08 April 2002 Location: United States Status: Offline Points: 4670	Post Options Post Reply Quote michael Report Post Thanks(0) Quote Reply 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.
	Blog \| MPG Tracker

ludovic Members Profile Find Members Posts Newbie Joined: 23 December 2003 Status: Offline Points: 3	Post Options Post Reply Quote ludovic Report Post Thanks(0) Quote Reply 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

michael Members Profile Find Members Posts Senior Member Joined: 08 April 2002 Location: United States Status: Offline Points: 4670	Post Options Post Reply Quote michael Report Post Thanks(0) Quote Reply 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.
	Blog \| MPG Tracker

ludovic Members Profile Find Members Posts Newbie Joined: 23 December 2003 Status: Offline Points: 3	Post Options Post Reply Quote ludovic Report Post Thanks(0) Quote Reply 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 !

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.