|
Home > Archive > MS SQL Server Tools > March 2006 > Microsoft SQL Server Management Studio
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Microsoft SQL Server Management Studio
|
|
| pd@acskive.dk 2006-03-22, 3:27 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
| |
| Andrew J. Kelly 2006-03-22, 7:31 am |
| Right click on the database in Object Explorer and choose "All Tasks". Then
choose export and follow the wizard.
--
Andrew J. Kelly SQL MVP
<pd@acskive.dk> wrote in message
news:1143018478.487953.10000@i40g2000cwc.googlegroups.com...
>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
>
|
|
|
|
|