Microsoft SQL Server Management Studio HELP!!! -- sql server (microsoft)

pd NO[at]SPAM acskive.dk
3/22/2006 1:28:00 AM

I have recently moved from a Microsoft SQL Server 2000 to a SQL Server
2005.

In the good old Enterprise Manager, when I imported a table from a SQL
server to another, I could choose "Copy objects and data between SQL
Server
databases". When choosen, all primary keys, and default values was
copied.

My question is:
Is it possible to do the same in Microsoft SQL Server Management Studio
with
SQL Server 2005? And how do I do it?

I have tried using the "SELECT * INTO NewTable FROM OldTable"
statement, but
it just drops all information about primary keys and default values.

Best Regards

RTL
3/22/2006 3:52:25 PM

I'm in the same boat as you. I found you can go to "all tasks > Copy
Database" and it will do similar. BUT, I have noticed that some views are
not carried over. So i'm researching out why they are not. I'm going to try
the detach/attach method myself next. It would be interesting to see what
you come up with as well.

Cheers,

Rich

[quoted text, click to view]

sql server (microsoft) : Microsoft SQL Server Management Studio HELP!!!