Import export tables

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
RIASAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vitor MontalvãoMSSQL Senior EngineerCommented:
That wizard is only to transfer data. If you want the table schema you'll need to use the Script Objects feature.
0
RIASAuthor Commented:
Vitor,
Can you point to steps please.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Right-click on the database name and select "Tasks" / "Generate Scripts...":
GenerateScripts.PNGThen, when setting the Options, click on "Advanced" and this will pop-up a new window where you can set to script "Schema and data" (be careful that this might generate a very big file if you're dealing with large tables). You can also see that it will script the Constraints by default:
Generate-Scripts---Schema-and-Data.PNG
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
RIASAuthor Commented:
As always Spot On!
0
RIASAuthor Commented:
Cheers!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.