We help IT Professionals succeed at work.

SQL Server tables only restore, structure compare

756 Views
Last Modified: 2013-11-30
Dear experts,
Just like in Oracle , using SQL Server , can i restore or export only the tables i need from and into a database?I guess by using DTS, is it? How owuld i create a dump file of only few tables, is it possible?
If so , how would i import (restore) just those tables from the dump file ?

Also, What is a good tool to do a strructural comparision between two SQL Server Databases and between a SQL Server and a Oracle database?

regards
Comment
Watch Question

AneeshDatabase Consultant
CERTIFIED EXPERT
Top Expert 2009
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.