Down Sizing from SQL server to MSDE?

Hi everyone,
Does anyone know if I can take tables from SQL server and somehow get them
into MSDE. I'm using Access as a front end to both servers. I know there is
a way to upsize databases, as well there should be, but what are my options
in terms of downsizing?
Thanks everyone
Take Care
SimonScripting the tables and then using INSERT INTO should work fine.
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Simon Harvey" <sh856531@.microsofts_free_emal_service.com> wrote in message
news:SerXa.52566$9C6.3100247@.wards.force9.net...
> Hi everyone,
> Does anyone know if I can take tables from SQL server and somehow get them
> into MSDE. I'm using Access as a front end to both servers. I know there
is
> a way to upsize databases, as well there should be, but what are my
options
> in terms of downsizing?
> Thanks everyone
> Take Care
> Simon
>|||I think I'd try sp_detachdb and sp_attachdb and see if that works ( it
should I think.)
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it community
of SQL Server professionals.
www.sqlpass.org
"Simon Harvey" <sh856531@.microsofts_free_emal_service.com> wrote in message
news:SerXa.52566$9C6.3100247@.wards.force9.net...
> Hi everyone,
> Does anyone know if I can take tables from SQL server and somehow get them
> into MSDE. I'm using Access as a front end to both servers. I know there
is
> a way to upsize databases, as well there should be, but what are my
options
> in terms of downsizing?
> Thanks everyone
> Take Care
> Simon
>