Data from multiple SQl Server Instances to a Central SQL Server for reporting purposes

Question

I have multiple (more then 20 locations having 10 Million Transactions/Year) locations with SQL server instances.

I need to move all these transactions (having independent identity on each site) from multiple sites to a Main SQL Instance in head office for reporting purpose only. I need solutions without using Bigint in Identity column and replication.

score 0 · Accepted Answer · answered Sep 24 '12 at 11:55

0

Try using NEWID() or NEWSEQUENTIALID()

answered Sep 24 '12 at 11:55

AnandPhadke

13,160
5
26
33

thanks for stopping by .But unique identifier (16bytes) will effect storage like bigint (8 bytes). – Born In Aban Sep 24 '12 at 12:30
when you say there are huge number of records then dont you think you need such datatypes to store the huge number – AnandPhadke Sep 24 '12 at 12:35
I guess you have to either use bigint or newid() and there is no other option in sql server as far as I know. – AnandPhadke Sep 24 '12 at 12:40

Data from multiple SQl Server Instances to a Central SQL Server for reporting purposes

1 Answers1