Copying tables with SQL Server 2005

#11

Parrot (Parrot (AT) discussions (DOT) microsoft.com) writes:

Quote:

How do you copy a table from one database to another database using SQL
Server Management Studio Express for SQL Server 2005? I was able to do
this easily with the Import/Export function in SQL Server 2000 but have
failed to find the equivalent in SQL Server Management Studio Express.
Do I need other software to do this?

The easiest way would undoubtedly be to write an INSERT statement...

I don't think the Import/Export tasks that Russell mentioned are available
in Mgmt Studio Express. But maybe you could make use of what the
Database Publishing Wizard produces. You find it at
http://www.microsoft.com/downloads/d...displaylang=en

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

#12

Parrot (Parrot (AT) discussions (DOT) microsoft.com) writes:

Quote:

How do you copy a table from one database to another database using SQL
Server Management Studio Express for SQL Server 2005? I was able to do
this easily with the Import/Export function in SQL Server 2000 but have
failed to find the equivalent in SQL Server Management Studio Express.
Do I need other software to do this?

The easiest way would undoubtedly be to write an INSERT statement...

I don't think the Import/Export tasks that Russell mentioned are available
in Mgmt Studio Express. But maybe you could make use of what the
Database Publishing Wizard produces. You find it at
http://www.microsoft.com/downloads/d...displaylang=en

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

#13

Parrot (Parrot (AT) discussions (DOT) microsoft.com) writes:

Quote:

How do you copy a table from one database to another database using SQL
Server Management Studio Express for SQL Server 2005? I was able to do
this easily with the Import/Export function in SQL Server 2000 but have
failed to find the equivalent in SQL Server Management Studio Express.
Do I need other software to do this?

The easiest way would undoubtedly be to write an INSERT statement...

I don't think the Import/Export tasks that Russell mentioned are available
in Mgmt Studio Express. But maybe you could make use of what the
Database Publishing Wizard produces. You find it at
http://www.microsoft.com/downloads/d...displaylang=en

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

#14

Parrot (Parrot (AT) discussions (DOT) microsoft.com) writes:

Quote:

How do you copy a table from one database to another database using SQL
Server Management Studio Express for SQL Server 2005? I was able to do
this easily with the Import/Export function in SQL Server 2000 but have
failed to find the equivalent in SQL Server Management Studio Express.
Do I need other software to do this?

The easiest way would undoubtedly be to write an INSERT statement...

I don't think the Import/Export tasks that Russell mentioned are available
in Mgmt Studio Express. But maybe you could make use of what the
Database Publishing Wizard produces. You find it at
http://www.microsoft.com/downloads/d...displaylang=en

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

#15

Parrot (Parrot (AT) discussions (DOT) microsoft.com) writes:

Quote:

How do you copy a table from one database to another database using SQL
Server Management Studio Express for SQL Server 2005? I was able to do
this easily with the Import/Export function in SQL Server 2000 but have
failed to find the equivalent in SQL Server Management Studio Express.
Do I need other software to do this?

The easiest way would undoubtedly be to write an INSERT statement...

I don't think the Import/Export tasks that Russell mentioned are available
in Mgmt Studio Express. But maybe you could make use of what the
Database Publishing Wizard produces. You find it at
http://www.microsoft.com/downloads/d...displaylang=en

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

#16

Parrot (Parrot (AT) discussions (DOT) microsoft.com) writes:

Quote:

How do you copy a table from one database to another database using SQL
Server Management Studio Express for SQL Server 2005? I was able to do
this easily with the Import/Export function in SQL Server 2000 but have
failed to find the equivalent in SQL Server Management Studio Express.
Do I need other software to do this?

The easiest way would undoubtedly be to write an INSERT statement...

I don't think the Import/Export tasks that Russell mentioned are available
in Mgmt Studio Express. But maybe you could make use of what the
Database Publishing Wizard produces. You find it at
http://www.microsoft.com/downloads/d...displaylang=en

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

#17

Parrot (Parrot (AT) discussions (DOT) microsoft.com) writes:

Quote:

How do you copy a table from one database to another database using SQL
Server Management Studio Express for SQL Server 2005? I was able to do
this easily with the Import/Export function in SQL Server 2000 but have
failed to find the equivalent in SQL Server Management Studio Express.
Do I need other software to do this?

The easiest way would undoubtedly be to write an INSERT statement...

I don't think the Import/Export tasks that Russell mentioned are available
in Mgmt Studio Express. But maybe you could make use of what the
Database Publishing Wizard produces. You find it at
http://www.microsoft.com/downloads/d...displaylang=en

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

#18

Parrot (Parrot (AT) discussions (DOT) microsoft.com) writes:

Quote:

How do you copy a table from one database to another database using SQL
Server Management Studio Express for SQL Server 2005? I was able to do
this easily with the Import/Export function in SQL Server 2000 but have
failed to find the equivalent in SQL Server Management Studio Express.
Do I need other software to do this?

The easiest way would undoubtedly be to write an INSERT statement...

I don't think the Import/Export tasks that Russell mentioned are available
in Mgmt Studio Express. But maybe you could make use of what the
Database Publishing Wizard produces. You find it at
http://www.microsoft.com/downloads/d...displaylang=en

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

#19

Parrot (Parrot (AT) discussions (DOT) microsoft.com) writes:

Quote:

How do you copy a table from one database to another database using SQL
Server Management Studio Express for SQL Server 2005? I was able to do
this easily with the Import/Export function in SQL Server 2000 but have
failed to find the equivalent in SQL Server Management Studio Express.
Do I need other software to do this?

The easiest way would undoubtedly be to write an INSERT statement...

I don't think the Import/Export tasks that Russell mentioned are available
in Mgmt Studio Express. But maybe you could make use of what the
Database Publishing Wizard produces. You find it at
http://www.microsoft.com/downloads/d...displaylang=en

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

#20

Thanks for your replies. It looks like the only way is to use an INSERT
command but I can't understand why the export/import function has been
removed from the Tasks menu. It seems like 2005 is a step down from 2000.
Dave

"Erland Sommarskog" wrote:

Quote:

Parrot (Parrot (AT) discussions (DOT) microsoft.com) writes:
How do you copy a table from one database to another database using SQL
Server Management Studio Express for SQL Server 2005? I was able to do
this easily with the Import/Export function in SQL Server 2000 but have
failed to find the equivalent in SQL Server Management Studio Express.
Do I need other software to do this?

The easiest way would undoubtedly be to write an INSERT statement...

I don't think the Import/Export tasks that Russell mentioned are available
in Mgmt Studio Express. But maybe you could make use of what the
Database Publishing Wizard produces. You find it at
http://www.microsoft.com/downloads/d...displaylang=en

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx