Copying tables with SQL Server 2005

#81

I am aware of the fact that I am using SQL Server Management Studio Express
rather than the regular Studio. The reason for that is that I couldn't find
SQL Server Management after installing SQL Server 2005 so I downloaded the
Express version. Are you saying that I can install SQL Server Mangement
Studio from my SQL Server 2005 installation disk and if so, do I just install
the server components part?
Dave

"Tibor Karaszi" wrote:

Quote:

I am not using SQL Server 2005 Express.

Below is a quote from your first post:

How do you copy a table from one database to another database using SQL
Server Management Studio Express for SQL Server 2005?

Can you see the contradiction between the two statements? :-)

It might be so that you didn't install Management Studio from the CD. I.e., you installed SSMS from
an Express download. I suggest that you in SSMS do Help, About to verify. I do know that the Import
and Export wizards are available in the regular SSMS.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

"Parrot" <Parrot (AT) discussions (DOT) microsoft.com> wrote in message
news:B8652D47-4E4F-4DE4-91F8-D48492163B58 (AT) microsoft (DOT) com...
I am not using SQL Server 2005 Express. I have the installation disk for SQL
Server 2005 Standard Edition. Does it not have the 2005 SQL Server
Management Studio like my SQL Server 2000 installation disk? If not, then
that is a downgrade.
Dave

"Tibor Karaszi" wrote:

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.

SQL Server 2000's Enterprise Manager should be compared to 2005's SQL Server Management Studio.
You
said you are using SQL Server Management Studio *Express* which is a *free* stripped SSMS. So,
you
are basically comparing apples with oranges. The Wizard in question *is* available in the pay
version of Management Studio.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

"Parrot" <Parrot (AT) discussions (DOT) microsoft.com> wrote in message
news:677B3F75-BC68-4D50-B6B8-5E6BA338D81B (AT) microsoft (DOT) com...
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:

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

#82

I am aware of the fact that I am using SQL Server Management Studio Express
rather than the regular Studio. The reason for that is that I couldn't find
SQL Server Management after installing SQL Server 2005 so I downloaded the
Express version. Are you saying that I can install SQL Server Mangement
Studio from my SQL Server 2005 installation disk and if so, do I just install
the server components part?
Dave

"Tibor Karaszi" wrote:

Quote:

I am not using SQL Server 2005 Express.

Below is a quote from your first post:

How do you copy a table from one database to another database using SQL
Server Management Studio Express for SQL Server 2005?

Can you see the contradiction between the two statements? :-)

It might be so that you didn't install Management Studio from the CD. I.e., you installed SSMS from
an Express download. I suggest that you in SSMS do Help, About to verify. I do know that the Import
and Export wizards are available in the regular SSMS.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

"Parrot" <Parrot (AT) discussions (DOT) microsoft.com> wrote in message
news:B8652D47-4E4F-4DE4-91F8-D48492163B58 (AT) microsoft (DOT) com...
I am not using SQL Server 2005 Express. I have the installation disk for SQL
Server 2005 Standard Edition. Does it not have the 2005 SQL Server
Management Studio like my SQL Server 2000 installation disk? If not, then
that is a downgrade.
Dave

"Tibor Karaszi" wrote:

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.

SQL Server 2000's Enterprise Manager should be compared to 2005's SQL Server Management Studio.
You
said you are using SQL Server Management Studio *Express* which is a *free* stripped SSMS. So,
you
are basically comparing apples with oranges. The Wizard in question *is* available in the pay
version of Management Studio.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

"Parrot" <Parrot (AT) discussions (DOT) microsoft.com> wrote in message
news:677B3F75-BC68-4D50-B6B8-5E6BA338D81B (AT) microsoft (DOT) com...
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:

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

#83

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

Quote: