Copying tables with SQL Server 2005

#21

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

#22

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

#23

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

#24

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

#25

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

#26

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

#27

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

#28

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

#29

Whoops. Must read more closely. The Database Publishing Wizard looks like it
might be the thing.

RLF

"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> 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

#30

Whoops. Must read more closely. The Database Publishing Wizard looks like it
might be the thing.

RLF

"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> 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