Copying Database, primary keys, and indexes.

[xtendscott]

I have a MSSQL database on a web host, where I have a web application that I want to create another similar one. Rather than having to request a backup of the database then restore to another database, I tried copying the tables over. This copied the tables and data, but primary keys, indexes and "auto INT" do not transfer.

Is there a way to do this?

xtendscott
Home Improvement Watch | Cryosurgery | Walla Walla Portal | Walla Walla Martial Arts

 

[vongrunt]

Use "Copy objects" option instead of "Copy tables".

Btw. be careful with "Copy dependent objects" option that appears in dialog later (aka: for starters, turn it off).

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[xtendscott]

So do you copy the tables and then copy the objects?

Thanks for the help.

xtendscott
Home Improvement Watch | Cryosurgery | Walla Walla Portal | Walla Walla Martial Arts

 

[vongrunt]

Nope... copy the objects directly.

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)