dbTalk Databases Forums  

Copying tables with SQL Server 2005

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss Copying tables with SQL Server 2005 in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Parrot
 
Posts: n/a

Default Copying tables with SQL Server 2005 - 02-26-2008 , 02:30 PM






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

Reply With Quote
  #2  
Old   
Russell Fields
 
Posts: n/a

Default Re: Copying tables with SQL Server 2005 - 02-26-2008 , 03:03 PM






Parrot,

Right click on the database in Object Explore, Tasks \ Export Data ... and
choose your behaviors.

RLF

"Parrot" <Parrot (AT) discussions (DOT) microsoft.com> wrote

Quote:
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



Reply With Quote
  #3  
Old   
Russell Fields
 
Posts: n/a

Default Re: Copying tables with SQL Server 2005 - 02-26-2008 , 03:03 PM



Parrot,

Right click on the database in Object Explore, Tasks \ Export Data ... and
choose your behaviors.

RLF

"Parrot" <Parrot (AT) discussions (DOT) microsoft.com> wrote

Quote:
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



Reply With Quote
  #4  
Old   
Russell Fields
 
Posts: n/a

Default Re: Copying tables with SQL Server 2005 - 02-26-2008 , 03:03 PM



Parrot,

Right click on the database in Object Explore, Tasks \ Export Data ... and
choose your behaviors.

RLF

"Parrot" <Parrot (AT) discussions (DOT) microsoft.com> wrote

Quote:
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



Reply With Quote
  #5  
Old   
Russell Fields
 
Posts: n/a

Default Re: Copying tables with SQL Server 2005 - 02-26-2008 , 03:03 PM



Parrot,

Right click on the database in Object Explore, Tasks \ Export Data ... and
choose your behaviors.

RLF

"Parrot" <Parrot (AT) discussions (DOT) microsoft.com> wrote

Quote:
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



Reply With Quote
  #6  
Old   
Russell Fields
 
Posts: n/a

Default Re: Copying tables with SQL Server 2005 - 02-26-2008 , 03:03 PM



Parrot,

Right click on the database in Object Explore, Tasks \ Export Data ... and
choose your behaviors.

RLF

"Parrot" <Parrot (AT) discussions (DOT) microsoft.com> wrote

Quote:
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



Reply With Quote
  #7  
Old   
Russell Fields
 
Posts: n/a

Default Re: Copying tables with SQL Server 2005 - 02-26-2008 , 03:03 PM



Parrot,

Right click on the database in Object Explore, Tasks \ Export Data ... and
choose your behaviors.

RLF

"Parrot" <Parrot (AT) discussions (DOT) microsoft.com> wrote

Quote:
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



Reply With Quote
  #8  
Old   
Russell Fields
 
Posts: n/a

Default Re: Copying tables with SQL Server 2005 - 02-26-2008 , 03:03 PM



Parrot,

Right click on the database in Object Explore, Tasks \ Export Data ... and
choose your behaviors.

RLF

"Parrot" <Parrot (AT) discussions (DOT) microsoft.com> wrote

Quote:
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



Reply With Quote
  #9  
Old   
Russell Fields
 
Posts: n/a

Default Re: Copying tables with SQL Server 2005 - 02-26-2008 , 03:03 PM



Parrot,

Right click on the database in Object Explore, Tasks \ Export Data ... and
choose your behaviors.

RLF

"Parrot" <Parrot (AT) discussions (DOT) microsoft.com> wrote

Quote:
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



Reply With Quote
  #10  
Old   
Russell Fields
 
Posts: n/a

Default Re: Copying tables with SQL Server 2005 - 02-26-2008 , 03:03 PM



Parrot,

Right click on the database in Object Explore, Tasks \ Export Data ... and
choose your behaviors.

RLF

"Parrot" <Parrot (AT) discussions (DOT) microsoft.com> wrote

Quote:
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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.