where is export import option in 2005

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

where is export import option in 2005

Author

Topic

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2007-09-06 : 04:14:57

hi all,
i didn't found the export import option in sql server 2005. experts, please guide me where can i found this?

Vinod
Even you learn 1%, Learn it with 100% confidence.

mwjdavidson
Aged Yak Warrior

735 Posts

Posted - 2007-09-06 : 04:24:01

Right-click on the database in Management Studio, and select "Tasks", "Import Data..." or "Export Data..."

Mark

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2007-09-06 : 04:25:58

there is no import and export

Vinod
Even you learn 1%, Learn it with 100% confidence.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-06 : 21:57:07

Do you use ssms express?

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-09-06 : 22:17:01

Sunsanvin, it is under tasks as Mark stated but at the bottom of the menu instead of at the top as it was in EM.

Future guru in the making.

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2007-09-07 : 05:27:55

I've been using SSMS.

in my server..(sys234),
databases is the first option..after click on that, i've system databases,database snap shots,mydb1,mydb2....like that.
i've right click on mydb1
there i used right click.
then the options are like this.
new database
new query
script database as->
tasks->
in the tasks,
detach
schrink->
backup
restore->
generate script.

are the options.
now where can i find export and import?
please let me know

Vinod
Even you learn 1%, Learn it with 100% confidence.

jaypee_s
Starting Member

22 Posts

Posted - 2007-09-07 : 05:40:19

DTS(import and export) have been replaced by SQL Server 2005 Integration Services (SSIS). More help go through msdn online help

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2007-09-07 : 05:42:03

how can i check wether SSIS is there on my system or not?

Vinod
Even you learn 1%, Learn it with 100% confidence.

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2007-09-07 : 05:49:45

i think there is only ssms in my system.SSIS was not installed.

Vinod
Even you learn 1%, Learn it with 100% confidence.

jaypee_s
Starting Member

22 Posts

Posted - 2007-09-07 : 05:51:11

Left side of your sql server 2005 .. Connect will be there just click you will get drop down box, there you can see integration services.

jaypee_s
Starting Member

22 Posts

Posted - 2007-09-07 : 05:57:58

In start - > program - > Sql server 2005 - > Sql server business intelligence development studio will be there. Click, in the left you can see...

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2007-09-07 : 07:13:41

the drop down list was not enabled i dont know why....
just now integration services and reporting services also installed in my machine

Vinod
Even you learn 1%, Learn it with 100% confidence.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-07 : 22:35:13

What's your sql2k5 edition? Double check with 'select @@version'.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources