Welcome to the FogBugz Knowledge Exchange

Question

1

Is it possible to merge two existing FogBugz databases ? The first one is in MSAccess format and the one that we want to merge into is SQL Server. My first thoughts were that there would likely be conflicts in the keys between one db and the other if I tried to do it manually once I had upgraded the first instance to SQL. I don't suppose there is some sort of wizard that will merge two instances ??

edited Aug 10 2010 at 13:35

adambox♦♦
23.9k●1●22●63

asked Aug 9 2010 at 0:33

Paul
11●1

adambox · Answer 1 · 2010-08-09 17:19:59Z UTC

1

You are right: there are a lot of foreign keys involved which make a merge impossible. The best way to migrate data into an existing FogBugz database is through the use of the XML API.

answered Aug 9 2010 at 17:19

adambox♦♦
23.9k●1●22●63

	Cheers for that. I will check it out when I have the time and give it a whirl {:o) – Paul Aug 10 2010 at 5:40
	If you have any questions, send them our way (contact link below). There are a couple of limitations to the XML API which you can find searching here. – adambox♦ Aug 10 2010 at 13:34

Is it possible to merge two existing FogBugz databases

1 Answer