 |
|
|
|
Next: Database Size Limiting
|
| Author |
Message |
External
Since: Sep 04, 2007
Posts: 12
|
(Msg. 1) Posted: Tue Feb 26, 2008 12:30 pm
Post subject: Copying tables with SQL Server 2005
Archived from groups: microsoft>public>sqlserver>tools (more info?)
|
|
|
|
| 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?
Dave
|
>> Stay informed about: Copying tables with SQL Server 2005 |
|
| Back to top |
|
 | |
External
Since: May 30, 2004
Posts: 1649
|
(Msg. 2) Posted: Tue Feb 26, 2008 3:18 pm
Post subject: Re: Copying tables with SQL Server 2005 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
External
Since: Sep 04, 2007
Posts: 12
|
(Msg. 3) Posted: Tue Feb 26, 2008 3:56 pm
Post subject: Re: Copying tables with SQL Server 2005 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
External
Since: Feb 21, 2007
Posts: 457
|
(Msg. 4) Posted: Tue Feb 26, 2008 4:03 pm
Post subject: Re: Copying tables with SQL Server 2005 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Parrot,
Right click on the database in Object Explore, Tasks \ Export Data ... and
choose your behaviors.
RLF
"Parrot" wrote in message
> 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?
> Dave >> Stay informed about: Copying tables with SQL Server 2005 |
|
| Back to top |
|
| |
External
Since: Feb 21, 2007
Posts: 457
|
(Msg. 5) Posted: Tue Feb 26, 2008 6:57 pm
Post subject: Re: Copying tables with SQL Server 2005 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
External
Since: Jan 29, 2004
Posts: 891
|
(Msg. 6) Posted: Wed Feb 27, 2008 8:03 am
Post subject: Re: Copying tables with SQL Server 2005 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
> 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" wrote in message
> 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@discussions.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/details.aspx?familyid=56E5B1C5-BF17...E0-A410
>>
>>
>> --
>> Erland Sommarskog, SQL Server MVP, esquel.RemoveThis@sommarskog.se
>>
>> Books Online for SQL Server 2005 at
>> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
>> Books Online for SQL Server 2000 at
>> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>> >> Stay informed about: Copying tables with SQL Server 2005 |
|
| Back to top |
|
| |
External
Since: Sep 04, 2007
Posts: 12
|
(Msg. 7) Posted: Wed Feb 27, 2008 8:41 am
Post subject: Re: Copying tables with SQL Server 2005 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
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" wrote in message
>
> > 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@discussions.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/details.aspx?familyid=56E5B1C5-BF17...E0-A410
> >>
> >>
> >> --
> >> Erland Sommarskog, SQL Server MVP, esquel.RemoveThis@sommarskog.se
> >>
> >> Books Online for SQL Server 2005 at
> >> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> >> Books Online for SQL Server 2000 at
> >> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
> >>
>
>
> >> Stay informed about: Copying tables with SQL Server 2005 |
|
| Back to top |
|
| |
External
Since: Feb 21, 2007
Posts: 457
|
(Msg. 8) Posted: Wed Feb 27, 2008 11:56 am
Post subject: Re: Copying tables with SQL Server 2005 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Then if you have the full SSMS then go back to my first answer. If you do
not see what I described, make sure that you are at least up to SP2 on your
SQL Server 2005 tools.
RLF
"Parrot" wrote in message
>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" wrote in message
>>
>> > 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@discussions.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/details.aspx?familyid=56E5B1C5-BF17...E0-A410
>> >>
>> >>
>> >> --
>> >> Erland Sommarskog, SQL Server MVP, esquel.DeleteThis@sommarskog.se
>> >>
>> >> Books Online for SQL Server 2005 at
>> >> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
>> >> Books Online for SQL Server 2000 at
>> >> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>> >>
>>
>>
>> >> Stay informed about: Copying tables with SQL Server 2005 |
|
| Back to top |
|
| |
External
Since: May 30, 2004
Posts: 1649
|
(Msg. 9) Posted: Wed Feb 27, 2008 3:07 pm
Post subject: Re: Copying tables with SQL Server 2005 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
External
Since: Sep 04, 2007
Posts: 12
|
(Msg. 10) Posted: Wed Feb 27, 2008 3:29 pm
Post subject: Re: Copying tables with SQL Server 2005 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
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?
Dave
"Erland Sommarskog" wrote:
> Parrot (Parrot@discussions.microsoft.com) writes:
> > 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.
>
> The tools ship with SQL 2005. However, if you have a single CD with
> SQL Server Standard, you don't have the tools, because they on CD 2.
> Which you also should have, unless some did it give you because of
> ignorance.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel.TakeThisOut@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
> >> Stay informed about: Copying tables with SQL Server 2005 |
|
| Back to top |
|
| |
External
Since: Jan 29, 2004
Posts: 891
|
(Msg. 11) Posted: Wed Feb 27, 2008 8:20 pm
Post subject: Re: Copying tables with SQL Server 2005 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
>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" wrote in message
>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" wrote in message
>>
>> > 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@discussions.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/details.aspx?familyid=56E5B1C5-BF17...E0-A410
>> >>
>> >>
>> >> --
>> >> Erland Sommarskog, SQL Server MVP, esquel.TakeThisOut@sommarskog.se
>> >>
>> >> Books Online for SQL Server 2005 at
>> >> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
>> >> Books Online for SQL Server 2000 at
>> >> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>> >>
>>
>>
>> >> Stay informed about: Copying tables with SQL Server 2005 |
|
| Back to top |
|
| |
External
Since: Sep 04, 2007
Posts: 12
|
(Msg. 12) Posted: Wed Feb 27, 2008 8:20 pm
Post subject: Re: Copying tables with SQL Server 2005 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
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" wrote in message
>
> >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" wrote in message
> >>
> >> > 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@discussions.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/details.aspx?familyid=56E5B1C5-BF17...E0-A410
> >> >>
> >> >>
> >> >> --
> >> >> Erland Sommarskog, SQL Server MVP, esquel.RemoveThis@sommarskog.se
> >> >>
> >> >> Books Online for SQL Server 2005 at
> >> >> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> >> >> Books Online for SQL Server 2000 at
> >> >> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
> >> >>
> >>
> >>
> >>
>
> >> Stay informed about: Copying tables with SQL Server 2005 |
|
| Back to top |
|
| |
External
Since: Jan 29, 2004
Posts: 891
|
(Msg. 13) Posted: Thu Feb 28, 2008 11:33 am
Post subject: Re: Copying tables with SQL Server 2005 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Yes, pop in the right CD and specify to install the workstation components. It will not remove your
existing database engine components. But you first need to remove SSMS Express, since SSMS express
cannot co-exist with the "real" SSMS.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Parrot" wrote in message
>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" wrote in message
>>
>> >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" wrote in message
>> >>
>> >> > 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@discussions.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/details.aspx?familyid=56E5B1C5-BF17...E0-A410
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Erland Sommarskog, SQL Server MVP, esquel DeleteThis @sommarskog.se
>> >> >>
>> >> >> Books Online for SQL Server 2005 at
>> >> >> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
>> >> >> Books Online for SQL Server 2000 at
>> >> >> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>> >> >>
>> >>
>> >>
>> >>
>>
>> >> Stay informed about: Copying tables with SQL Server 2005 |
|
| Back to top |
|
| |
External
Since: May 30, 2004
Posts: 1649
|
(Msg. 14) Posted: Thu Feb 28, 2008 2:55 pm
Post subject: Re: Copying tables with SQL Server 2005 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Parrot (Parrot@discussions.microsoft.com) writes:
> 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?
Yes. I would start with the first CD, and then select workstation
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.DeleteThis@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx >> Stay informed about: Copying tables with SQL Server 2005 |
|
| Back to top |
|
| |
External
Since: Mar 08, 2008
Posts: 3
|
(Msg. 15) Posted: Sat Mar 08, 2008 8:37 am
Post subject: Re: Copying tables with SQL Server 2005 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
You can use the SELECT INTO statement
--BEGIN TRANSACTION
SELECT * INTO Database2.dbo.Contacts FROM Database1.dbo.Contacts
Verify the table
SELECT * FROM Database2.dbo.Contacts
The run the following if everything is correct
-- COMMIT TRANSACTION
or Roll it back if that is not what you are looking for.
-- ROLLBACK TRANSACTION
Samson
"Parrot" wrote in message
> 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?
> Dave >> Stay informed about: Copying tables with SQL Server 2005 |
|
| Back to top |
|
| |
| Related Topics: | SQL Server 2005 - Server side trace script - Hi, I have been beating my head against the wall on this one, and am hoping someone can point out what I am doing wrong here. I am trying to set up a trace (using script) that will tracks all the "RPC:Completed" events and give me some of t...
Copying database between servers - I need to move a SQL 2005 database between 2 servers. But the 2 servers have different path structure due to language difference. One server has the databse installed under "c:\Program Files ..." and the other under "C:\Programmer...&quo...
Copying a database with the "Copy Database Wizard" - I am using the Copy Database wizard to copy an SQL 2000 database to a 2005 database on another server. When I get to the "Schedule the Package" wizard and click "Next>" I get an error that says "Proxy account has to be selec...
debugging in sql server 2005 - Can you 'step' through code in sql server 2005 express like you can in visual studio.net 2005? I want to be able to debug code on my own workstation since my company does not have a 'test' sql server for me to use. Does the developer's version of sql....
Manage SQL Server 2005 while keeping SQL Server 2000 - I've got SQL Server 2000 running on my PC, and I want to continue doing so. But now I also need to manage a remote SQL Server 2005 database. I think that I need to install SQL Server Management Studio to do so. (Please correct me if that's wrong.) Can... |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
