ZZartin- I ran below script on my new SQL server using LinkedServers. The tables did not update. I mean I checked few tables. The number of rows in the original database are more than the number of rows in the new database. Any suggestions/help is greatly appreciated.

SELECT 'TRUNCATE TABLE ' + TABLE_SCHEMA + '.' + TABLE_NAME + '; INSERT INTO ' + TABLE_SCHEMA + '.' + TABLE_NAME +

' SELECT * FROM <TestServer>.<TestDB>.' + TABLE_SCHEMA + '.' + TABLE_NAME + ';'

FROM INFORMATION_SCHEMA.TABLES

WHERE TABLE_TYPE = 'BASE TABLE'