Backup&Restore - Export&Import

• dsankarmca

  Grasshopper

  Points: 12

  More actions

  January 30, 2012 at 11:22 pm

  #391435

  Dear All,

  I am new in SQL_Server.

  i am using,

  -----------

  Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)

  Feb 9 2007 22:47:07

  Copyright (c) 1988-2005 Microsoft Corporation

  Standard Edition on Windows NT 5.2 (Build 3790: Service Pack

  My requirement like,

  --------------------

  Using one bat file and properties file , need to take the backup or export the dump from specified database in properties file and restore or import the dump to specified database in properties file.

  Thanks for any help.

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  January 31, 2012 at 3:13 am

  #1440452

  Oracle user, right? 🙂

  The equivalent of imp/exp is BCP. Look it up in Books Online.

  -- Gianluca Sartori

• dsankarmca

  Grasshopper

  Points: 12

  More actions

  February 1, 2012 at 5:50 pm

  #1441500

  Gianluca Sartori (1/31/2012)

  ---

  Oracle user, right? 🙂

  The equivalent of imp/exp is BCP. Look it up in Books Online.

  Hi..

  Thanks for your reply..

  Before that i am using MySql.

  But i am not handled such things..like import,export,backup,restore etc..