 | |
#101
 
| |||
| |||
|
Re: Copying tables with SQL Server 2005 -
02-28-2008
, 04:33 AM
|
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: 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 |
#102
| |||
| |||
|
|
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: 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 |
#103
| |||
| |||
|
|
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: 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 |
#104
| |||
| |||
|
|
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: 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 |
#105
| |||
| |||
|
|
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: 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 |
#106
| |||
| |||
|
|
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: 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 |
#107
| |||
| |||
|
|
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: 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 |
#108
| |||
| |||
|
|
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: 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 |
#109
| |||
| |||
|
|
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: 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 |
#110
| |||
| |||
|
|
Yes, I do have the 2nd CD for SQL Server 2005. I don't know why it didn't install the first time around. To install SQL Server Management Studio which disk should I insert? I tried both disks and each time it acts like it wants to reinstall SQL Server 2005 which I don't want to do and so I cancelled. Can I install Server Management without re-installing SQL Server itself? |
components only. If you were to select Database Engine, you would install
a second instance.
But I have heard of people who have inserted the Tools disk and then
started the setup from there. I will have to admit that sounds a little
spooky to me, as the feature selection is on the first disk. Then again,
I guess you can run that setup from the command line.
--
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.