All geek questions in one place

Combining multiple Access databases in SQL Server

We have a program in which each user is provided with their own Access database. We would like to combine them all together into one SQL Server database.

The problem is that using the SQL Server Import / Export Wizard, primary / foreign keys are not updated. So, for example, if one user has this table:

1 Apple
2 banana

and another user has the following:

1 Coconut
2 Cheeseburger

The final table is as follows:

1 Apple
2 banana
1 Coconut
2 Cheeseburger

Similarly, everything that refers to the Banana by its primary key (2) now refers to both the Banana and the Cheeseburger, which will not make vegans very happy.

/ , - script?

+3
4

SSIS . SSIS , Microsoft ( "Business Integration Studio", SQL Server), .

0

, - . , SQL Server, ​​ , Access? SQL Server ? RI. serverid/siteid/customerid. , UDF, . - .

SQL Server , (.. , ), .

, .

0

.

: " ?" 1: T A; 1: T B. , T . , , : () (, ) / (b) .

"", , , . SQL SQL , . , , ( "" ) .

"", , , . , -, .

, , , : , . : ( ) D , "A: 1: a", "A: 2: b", "B: 1: c", "B: 2: d", "B: 15: a, '' C: 8: a '; () T1 , " a: apple "," b: banana "," c: coconut "," d: cheeseburger ", " A " ," 1 " " A "" a" - , D T1. ( , : A: 1: apple, B: 15: apple, C: 8: apple.) , T1 , T, , , .

0

Access ? SQL Server. , . , SQL Server.

Access ? Access 2000. , .

http://technet.microsoft.com/en-us/library/cc751054.aspx

-1

Source: https://habr.com/ru/post/1754306/

More articles:


All Articles