Working with data on SQL Server 2008R2

Question

We have datawarehouse on SQL Server 2008R2. We have another server where SQL Server 2012 is installed.

How to clean data on SQL Server 2008R2. Can DQS of SQL Server 2012 access the another SQL server or should data imported from SQL Server 2008R2 to SQL Server 2012 and  cleaned and export back?

---

Kenny_I

Answer 1

Hi Kenny,

You can use the Linked Server feature in SQL Server to access data from a remote SQL Server database for DQS operations. For information on how to do so, please see the following article: Accessing your Data on Remote Servers for DQS Operations by Linking Servers.

However, you can export the cleansed data only to a database that is available in the same SQL Server 2012 instance as Data Quality Server, and then transfer it to your source database. Please note that using DQS, you can only export the cleansed data to a new table in a database or to an Excel/CSV file; you cannot overwrite your source data with the cleansed data. More information about exporting cleansed result available here.

Thanks
Vivek
(SQL Server Documentation | Twitter: @vivek_msft)

---

NOTE: Please remember to appropriately vote a post as "helpful" or mark as "answer" to help the community.

---