Copy Some Table data from production

• poratips

  Hall of Fame

  Points: 3994

  More actions

  November 8, 2012 at 10:09 pm

  #266839

  I have a situation that my developer wants some tables from Prodction DB server to their desktop m/c.

  We have already sql express installed and Database and tables ae already there but no data.

  In this Database, we need some of the tables with for specific date and dept.

  What will be the best way to handle this?

  My problem is that i can't use Task - Copy wizard from prod server as i need some tables need to copy data full and some of the tables i need to restrict by Date.

  This will be recurring base so i am looking right approach.

  Thanks,

• sanket kokane

  Hall of Fame

  Points: 3465

  More actions

  November 8, 2012 at 10:36 pm

  #1557440

  You can use import export wizard .

  and wherever you need data for specific date and dept ,use query in the import wizard

  select * from yourtable where date ='date ' and dept = 'dept'

  -----------------------------------------------------------------------------
  संकेत कोकणे