 | |
#31
 
| |||
| |||
|
Re: Copying tables with SQL Server 2005 -
02-26-2008
, 05:57 PM
|
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 |
#32
| |||
| |||
|
|
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 |
#33
| |||
| |||
|
|
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 |
#34
| |||
| |||
|
|
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 |
#35
| |||
| |||
|
|
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 |
#36
| |||
| |||
|
|
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 |
#37
| |||
| |||
|
|
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 |
#38
| |||
| |||
|
|
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. |
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
Quote:
|
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 |
#39
| |||
| |||
|
|
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. |
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
Quote:
|
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 |
#40
| |||
| |||
|
|
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. |
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
Quote:
|
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 |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.