How to create a new Database and copy data from existing DB

• siva.vgv

  Newbie

  Points: 9

  More actions

  June 11, 2010 at 12:03 am

  #387133

  Hi,

  On daily basis I want to create a Database and after that I want to copy data from another database. I want to copy only few tables from another database not a whole copy. While copying I want to get all the primary keys and constraints on the tables. Please suggest me a good approach for this.

  Regards,

  Siva

• parthenitin

  Ten Centuries

  Points: 1190

  More actions

  June 11, 2010 at 12:32 am

  #1179029

  Hi,

  Can you tell me why u r goin to Create Database on daily basis.

  rather than you can do

  scripts for defination of tables and their constraints(one time only),

  scrips for truncating all tables that required(daily).

  and another for copying Data.

  It will be easier.

  Regards,

  Nitin S. Parthe