No Import/Export Option in Mgmt Studio Express

Hi,

I just installed SQL Server 2005 Express. I would like to import tables from

another DB, and I read in the help files that I just need to (1) right-click on

a non-system database in Management Studio Express, and (2) select Import/Export

under the Tasks menu.

I tried this, but my Tasks menu only contains these options: Detach, Shrink,

Backup, Restore, Generate Scripts.

I googled for \"sql server 2005 "no import" tasks\", and it appears that a

couple of people have had this problem -- the only solution I read was to

install the "Workstation Components," but I already have, and still no luck.

Any idea what I need to do? Thanks!

Did you try right clicking on the database in the object explorer window. Try that, and then the All Tasks, Generate SQL Scripts option.|||Okay, I right-clicked on my database in the object explorer, then went to Tasks->Generate Scripts. This database is empty, though (I want to import a SQL Server 7 DB into it), so I end up getting a message that says "There are no objects in database of the types scriptable by this wizard."

Ultimately, I just need to import a SQL Server 7 database into SQL Server 2005 Express, but I can't find an "import" option in 2005. Is there some component I need to install?|||Ah, I think I need SQL Server Integration Services (SSIS), and that is apparently not included in SQL Server 2005 Express Edition (see "Unsupported Features" in http://msdn2.microsoft.com/en-us/library/ms365166.aspx). Mystery solved.

No "Maintenance Plans" under SQL Server 2005

Running "SQL Server Mgmt Studio"
For the software "SQL Server 2005"
Under the SERVER instance, there's Mgmt -> Maint Plans.
Under SERVER\INSTANCE, there's no Maintenance Plans.
The DBs I need to back up are under SERVER\INSTANCE.
Any idea why my server instance does not have the option?
Thanks,
ScottThere are none by default, you have to create them. Right click and say "New
Maintenance Plan" or choose the wizard.
--
Andrew J. Kelly SQL MVP
"Scott Moseman" <scmoseman@.gmail.com> wrote in message
news:1157491039.842488.194100@.m79g2000cwm.googlegroups.com...
> Running "SQL Server Mgmt Studio"
> For the software "SQL Server 2005"
> Under the SERVER instance, there's Mgmt -> Maint Plans.
> Under SERVER\INSTANCE, there's no Maintenance Plans.
> The DBs I need to back up are under SERVER\INSTANCE.
> Any idea why my server instance does not have the option?
> Thanks,
> Scott
>|||Scott Moseman wrote:
> Running "SQL Server Mgmt Studio"
> For the software "SQL Server 2005"
> Under the SERVER instance, there's Mgmt -> Maint Plans.
> Under SERVER\INSTANCE, there's no Maintenance Plans.
> The DBs I need to back up are under SERVER\INSTANCE.
> Any idea why my server instance does not have the option?
> Thanks,
> Scott
>
Skip the maintenance plan and use a scheduled T-SQL script to do your
backups. See
http://realsqlguy.com/serendipity/archives/11-Send-In-Backup!.html for a
script that will backup every database on your server, all you have to
do is schedule it to run.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||I'm not talking about it missing a maintenance plan, I'm talking
about the Management folder not even having the Maintenance
Plan subfolder under which you'd add any new plans. Adding a
maintenance plan is not a problem, but there's no place to do it.
Thanks,
Scott
Andrew J. Kelly wrote:
> There are none by default, you have to create them. Right click
> and say "New Maintenance Plan" or choose the wizard.
> --
> Andrew J. Kelly SQL MVP
>
> "Scott Moseman" <scmoseman@.gmail.com> wrote:
> > Running "SQL Server Mgmt Studio"
> > For the software "SQL Server 2005"
> >
> > Under the SERVER instance, there's Mgmt -> Maint Plans.
> > Under SERVER\INSTANCE, there's no Maintenance Plans.
> >
> > The DBs I need to back up are under SERVER\INSTANCE.
> > Any idea why my server instance does not have the option?
> >
> > Thanks,
> > Scott
> >|||Hi,
I had the same problem.
You need to install Integration Services also for that instance
SERVER\INSTANCE.
HTH
Flor
Tracy McKibben a =E9crit :
> Scott Moseman wrote:
> > Running "SQL Server Mgmt Studio"
> > For the software "SQL Server 2005"
> >
> > Under the SERVER instance, there's Mgmt -> Maint Plans.
> > Under SERVER\INSTANCE, there's no Maintenance Plans.
> >
> > The DBs I need to back up are under SERVER\INSTANCE.
> > Any idea why my server instance does not have the option?
> >
> > Thanks,
> > Scott
> >
> Skip the maintenance plan and use a scheduled T-SQL script to do your
> backups. See
> http://realsqlguy.com/serendipity/archives/11-Send-In-Backup!.html for a
> script that will backup every database on your server, all you have to
> do is schedule it to run.
> > > -- > Tracy McKibben
> MCDBA
> http://www.realsqlguy.com

No "Maintenance Plans" under SQL Server 2005

Running "SQL Server Mgmt Studio"
For the software "SQL Server 2005"
Under the SERVER instance, there's Mgmt -> Maint Plans.
Under SERVER\INSTANCE, there's no Maintenance Plans.
The DBs I need to back up are under SERVER\INSTANCE.
Any idea why my server instance does not have the option?
Thanks,
ScottThere are none by default, you have to create them. Right click and say "New
Maintenance Plan" or choose the wizard.
Andrew J. Kelly SQL MVP
"Scott Moseman" <scmoseman@.gmail.com> wrote in message
news:1157491039.842488.194100@.m79g2000cwm.googlegroups.com...
> Running "SQL Server Mgmt Studio"
> For the software "SQL Server 2005"
> Under the SERVER instance, there's Mgmt -> Maint Plans.
> Under SERVER\INSTANCE, there's no Maintenance Plans.
> The DBs I need to back up are under SERVER\INSTANCE.
> Any idea why my server instance does not have the option?
> Thanks,
> Scott
>|||Scott Moseman wrote:
> Running "SQL Server Mgmt Studio"
> For the software "SQL Server 2005"
> Under the SERVER instance, there's Mgmt -> Maint Plans.
> Under SERVER\INSTANCE, there's no Maintenance Plans.
> The DBs I need to back up are under SERVER\INSTANCE.
> Any idea why my server instance does not have the option?
> Thanks,
> Scott
>
Skip the maintenance plan and use a scheduled T-SQL script to do your
backups. See
http://realsqlguy.com/serendipity/a...-Send-In-Backup!.html for a
script that will backup every database on your server, all you have to
do is schedule it to run.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||I'm not talking about it missing a maintenance plan, I'm talking
about the Management folder not even having the Maintenance
Plan subfolder under which you'd add any new plans. Adding a
maintenance plan is not a problem, but there's no place to do it.
Thanks,
Scott
Andrew J. Kelly wrote:[vbcol=seagreen]
> There are none by default, you have to create them. Right click
> and say "New Maintenance Plan" or choose the wizard.
> --
> Andrew J. Kelly SQL MVP
>
> "Scott Moseman" <scmoseman@.gmail.com> wrote:
>|||Hi,
I had the same problem.
You need to install Integration Services also for that instance
SERVER\INSTANCE.
HTH
Flor
Tracy McKibben a =E9crit :

> Scott Moseman wrote:
> Skip the maintenance plan and use a scheduled T-SQL script to do your
> backups. See
> http://realsqlguy.com/serendipity/a...-Send-In-Backup!.html for a
> script that will backup every database on your server, all you have to
> do is schedule it to run.
>=20
>=20
> --=20
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com