Restore tables only from backup.

[djj55]

Hello, SQL 2008R2
Is it possible to restore just the table and not the stored procedures/user defined functions, from a full backup?

This would be used to update our development server.

Thanks,

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!

 

[fredericofonseca]

not natively - only way with plain SQL Server tools is to restore the whole database.

What most do is to restore to another database, and then copy the objects required to the real destination database.

Some commercial tools seem to allow for this. RedGate might be one of them, but I don't know for sure.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[djj55]

I can copy the tables directly, but with foreign keys and other things it is a real pain, yet it can be done.

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!

 

[metevil80]

You can do a bcd through the cmd prompt, here is a link on how to use it

http://www.techrepublic.com/blog/datacenter/how-do-i-use-bcp-in-sql-server/319.

That or if you just need a few rows you can write an insert statement.
If you want to create a new table and you have a backup of the database that had the original table in question, and a test database to restore that backup to you can write a insert which I've included an example of below.

Create Table dbo.<your new table name>(
<Columns> (Ex: [Name] [char] (15) NOT NULL)
)

Insert into dbo.<your new table name>

SELECT <columns from other table that match colums in new table created>
FROM <database name>.dbo.<original table name>