 | |
#41
 
| |||
| |||
|
Re: Copying tables with SQL Server 2005 -
02-27-2008
, 06:05 AM
|
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 |
#42
| |||
| |||
|
|
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 |
#43
| |||
| |||
|
|
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 |
#44
| |||
| |||
|
|
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 |
#45
| |||
| |||
|
|
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 |
#46
| |||
| |||
|
|
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 |
#47
| |||
| |||
|
|
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 |
#48
| |||
| |||
|
|
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 |
#49
| |||
| |||
|
|
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 |
#50
| |||
| |||
|
|
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 |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.