Home / server / Questions / 237030
Accepted
Aren B
Asked: 2011-02-18 16:21:41 +0800 CST

Import / Export / Backup Single MSSQL Table

  • 772

I am trying to migrate specific tables entire dataset from my DEV machine to our staging machine. (Has all the basic starting data for this feature).

Essentially what I want to do is akin to the backup/restore operation for databases, but I only want to do this for a select couple of tables in my database.

Is this possible? I've searched long and hard for MSSQL -> MSSQL Table Migration or export/import and I've come up with not a lot.

sql-server migration

2 Answers

  1. Generally what you will have to do is generate scripts for the objects using Management Studio (or Enterprise Manager/Query Analyzer for 2000 and earlier), run these to create the objects on the staging server, and then use the Import/Export Wizard in Integration Services (or DTS for 2000 and earlier) to actually transfer the data to the destination server.

    You could probably also use on-demand snapshot replication to push the objects to the target server, though making schema changes after that would require dropping the publication, or at the very least removing the objects from it.

    • 1
  2. Best Answer

    There is no native object level restore. However Quest Software, and RedGate both have products that can do object level restore. (I know that Quest does, I'm like 99% sure about RedGate.)

    • 1