Copy database fields SQL Management Express 2005

I've created a load of tables and fields in the wrong database, I'm trying to copy/paste the fields accross but Management Express is having none of it.
I can't use the Publishing Wizard as both source and target db's have many more tables in and the Publishing Wizard doesn't seem to have a 'select tables' option, is there any way other than typing?
(And before you ask, no I didn't create scripts to generate the tables as you're supposed to, I used the UI)
Silas2Asked:
Who is Participating?
 
tim_csCommented:
Not sure if Express has this option but right click on the database you are trying to move from and look for Tasks -> Generate Scripts.  From there you should be able to generate the scripts for all of the desired tables.  
0
 
Silas2Author Commented:
That's it, thanks. Saved me hours.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.