August 21, 2012 at 1:45 pm
I have a user wanting to transfer data from one database to another within MSSQL 2008 R2. They are wanting to transfer data from one report tracking SW (TestTrack) to another (MS Team Foundation Server). Is there a way to do this visually or simply, perhaps some tools, without having to use extensive select/insert statements?
August 22, 2012 at 7:30 am
are you talking about only few tables? if then try import/export.
Regards
Durai Nagarajan
August 22, 2012 at 12:15 pm
chrisph (8/21/2012)
I have a user wanting to transfer data from one database to another within MSSQL 2008 R2. They are wanting to transfer data from one report tracking SW (TestTrack) to another (MS Team Foundation Server). Is there a way to do this visually or simply, perhaps some tools, without having to use extensive select/insert statements?
Are they trying to move where the data (or metadata) is stored, as in the version documents, or are they trying to switch products completely and moved the stored data between the two applications without using the interface?
Swapping without the interface can be BAD. TFS makes certain assumptions about other data it has when it stores stuff (labels, versions, check in histories, etc) and if you don't nail these perfectly it'll foul up.
In either case, you're changing products. I would not move ANY data directly between the two (ie: outside standard interfaces) without testing and evaluation as to getting everything lined up precisely. You simply can't be sure of the results otherwise... they're both vendor software who are not standardized to each other.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
August 23, 2012 at 9:19 am
We use a tool called Apex SQL Diff. It was once reviewed by this very site.
http://www.apexsql.com/sql_tools_diff.aspx
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply