We help IT Professionals succeed at work.

Import export tables

RIAS
RIAS asked
on
97 Views
Last Modified: 2018-03-28
Hello,
When i import tables from one database to other by import export wizard, the constraints are not copied.
I am using sql server 2014 .

Cheers
Comment
Watch Question

Vitor MontalvãoIT Engineer
CERTIFIED EXPERT
Distinguished Expert 2017

Commented:
That wizard is only to transfer data. If you want the table schema you'll need to use the Script Objects feature.

Author

Commented:
Vitor,
Can you point to steps please.
IT Engineer
CERTIFIED EXPERT
Distinguished Expert 2017
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION

Author

Commented:
As always Spot On!

Author

Commented:
Cheers!