Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Data migration Expand / Collapse
Author
Message
Posted Tuesday, July 15, 2014 7:18 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 21, 2014 1:27 AM
Points: 19, Visits: 181
I have a cluster hosting multiple GP databases and a second for my data-warehouse I am playing around with (personal project).

I have scripts that pull data from all the DB's to input into the DW's tables(Customers,Reps,Hub....)

an example of my branch script :
select interid as BranchID,
cmpnynam as BranchDesc,
address1 as BranchAddressLine1,
address2 as BranchAddressLine2,
address3 as BranchAddressLine3,
zipcode as PostalCode
from dynamics..SY01500
where interid in ('comp1', 'comp2', 'comp4', 'comp5')

what would be the best way to using these scripts pull the data to my testDW and not have duplicate data issues?

I was thinking of using a staging DB on the GP cluster and then building an import data package to run nightly. the issue i had was how do i avoid duplicate data ?

Post #1592546
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse