0
votes
2answers
894 views

Doing a comparison on two csv files with no Primary Key

I'm wondering if in SSIS there is a way to compare two csv files(with the same structure) with no reference key to make a record unique. To give you a better picture from what I mean; In initial load ...
2
votes
1answer
250 views

Data migration between databases in the same instance

I have two almost identical (structurally) databases: Documents DocumentsOld The original database existed before table partitioning was available, so the solution they found was to create the ...
4
votes
1answer
5k views

Migrating from one SQL Server 2008 R2 instance to another

I just started a new dba job and have been given a new server and told to move everything from the old server to the new one, brand new windows and SQL Server installations. I know I have to transfer ...