Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Import/Export in SQL 2005 management studio exppress edition
- Thread starter royyan
- Start date
- Thread starter
- #2
mrdenny
Programmer
- May 27, 2002
- 11,595
Import/export is actually part of DTS. DTS is not called Integration Services and isn't included in the Express edition.
Denny
MCSA (2003) / MCDBA (SQL 2000)
--Anything is possible. All it takes is a little research. (Me)
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
Denny
MCSA (2003) / MCDBA (SQL 2000)
--Anything is possible. All it takes is a little research. (Me)
- Thread starter
- #4
Hi Denny, Thank you for taking time answering the question. Yes, there is no import/export wizard in Management Studio Express. The import/export wizard in full Management Studio relies on SQL Server Integration Services to move the data, but SSIS is not present when only SQL Server Express is installed.
mrdenny
Programmer
- May 27, 2002
- 11,595
no problem.
Denny
MCSA (2003) / MCDBA (SQL 2000)
--Anything is possible. All it takes is a little research. (Me)
Denny
MCSA (2003) / MCDBA (SQL 2000)
--Anything is possible. All it takes is a little research. (Me)
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
