What is the best way to partially import data from another database

• Sunita-226172

  SSC Rookie

  Points: 38

  More actions

  August 5, 2005 at 9:59 am

  #88594

  I am trying to import data from another SQL database residing on different server, I would like to import only 6 months worth of data, is there any good way to do this?

  Thanks for all help ..

   

   

   

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  August 5, 2005 at 10:01 am

  #580099

  Insert into dbo.LocalTable (col1, col2) Select col1, col2 from LinkedServerName.DbName.dbo.TableName where DateDate between @Start and @End

  Look up linked servers in books online.

• lopeter

  SSC Veteran

  Points: 261

  More actions

  August 8, 2005 at 9:08 am

  #580452

  You can create a view which has the same column list as your source table and a WHERE clause:

  create view v_xxx

  ..

  as

  select

  ..

  from <source table>

  where <column> >= dateadd(day, -180, getdate())

  go

   

  Then, you can BCP out data from view, then BCP in data into your target table

   

  -- Peter Lo