Can't Import

[OAKEJ]

I have read/write permissions to a database but when I right click on the database>Tasks>, I have no option to import. The options that I do have are: Detach, Shrink, Backup, Restore & Generate Scripts. Any Ideas of what it could be?

 

[mrdenny]

What version are you using?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[OAKEJ]

SQL Server Management Studio Express 2005

 

[mrdenny]

Management studio express doesn't give you import and export functionality as SQL Express doesn't include SSIS.

You will need to either use the BCP command line tool or get the full version of the SQL Server Management studio from one of the full editions of SQL Server.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[OAKEJ]

how do you use the BCP command line tool

 

[mrdenny]

If you go to the command prompt and type

bcp /?

It will give you the syntax.

The basic syntax is

bcp "master.dbo.sysfiles" out "C:\exportfile.csv" -S ServerName -T -b 1000 -w

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog