SQL tables help

[al_galiza]

I have a CF calendar application that I want to replicate, so it involves
copying one SQL database to another. There are 10 SQL databases that I have to
copy the EXACT table design. Is there a way to do this in SQL Enterprise
Manager other than importing from the original db to the new and reapplying the
table design? I'm no SQL admin expert, and I don't know enough about SQL query
writing to automate and transfer, but would be happy to learn if someone could
point me to the a good starting place.

Thanks.

[jorgepino]

yes. Import it to the same table but make sure to change the Table Name
You can copy with the all data or just the structrure

[mxstu]

If you need to copy the entire database, and this is a one time operation, a
simple way is to make a backup of the database you want copy and then restore
the back-up into the new database. Take a look at Enterprise manager's
backup/restore wizards. If you will need to perform this task more than once,
you may want to look into
[url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replove[/url]
r_694n.asp. Good Luck