Looping through non replicated tables for data

• Studdy05

  Ten Centuries

  Points: 1375

  More actions

  November 13, 2007 at 9:19 am

  #376974

  I have a 2500 table db that has about 50 tables in it being replicated to one other server/db. The other database was a backup when this all started and I have been wanting to "freshen up" many of those stale tables. I can use sysobjects to select the tables I want to export over to the stale data tables.

  From that point on, things start getting a little fuzzy and I am wanting to avoid DTS/SSIS packages just because of the number of tables my result set has in it.

  Suggestions? Ideas? Scripts?

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738589

  More actions

  November 26, 2007 at 11:12 am

  #754172

  I'd use the DTS/SSIS wizard. Easier to set this up once, then you can periodically run it against the tables.

  You could BCP out/in, http://www.sqlservercentral.com/scripts/Backup+%2F+Restore/30027/, use the select from sysobjects to power it.