Unanswered: HowTo compare data from 2 different db-sources (xls,csv,sql server, mysql server)?
I'm searching for a way to compare informations from one database against another database.
E.g. i want to check if serialnumbers of my first database (eg hardware.xls or hardware.csv ) are already stored in my sql server database.
I know i can use sql querys (Joins) for that task but i don't know how i can access 2 different databases at the same time. Do i need a tool for it? Does Excel is able to compare those data? But how? I'm searching for that thread since 2 days testing with some tools without any success...
There may be an easier way to do this, but you can use a linked server. Setup a new linked server in SQL Management Studio (under Server Objects) to point to your second database. Then you can write a query against tables in that database by referencing the tables in a format such as server.database.schema.table. You can even create views in your SQL Server database to make queries against the linked server easier. Hope that helps.