Downsizing to Access?

Hi,
Does anyone happen to know if it is possible to downsize a SQL Server
database to an Access mdb file? The reason I ask is because I want to use an
mdb file to transport the SQL Server database from a to b, and then upsize
the mdb database to SQL Server.
Unless there is an easier way to transport SQL Server databases including
views and stored procedures?
Thanks all
SimonTry sp_detach_db and sp_attach_db.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Simon Harvey" <simon.harvey@.the-web-works.co.uk> wrote in message
news:%23Lik0fo5DHA.2380@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Does anyone happen to know if it is possible to downsize a SQL Server
> database to an Access mdb file? The reason I ask is because I want to use
an
> mdb file to transport the SQL Server database from a to b, and then upsize
> the mdb database to SQL Server.
> Unless there is an easier way to transport SQL Server databases including
> views and stored procedures?
> Thanks all
> Simon
>|||Look into sp_detach_db and sp_attach_db in BOL.
This will allow you to transport the db with ease.
-Lars
"Simon Harvey" <simon.harvey@.the-web-works.co.uk> wrote in message
news:%23Lik0fo5DHA.2380@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Does anyone happen to know if it is possible to downsize a SQL Server
> database to an Access mdb file? The reason I ask is because I want to use
an
> mdb file to transport the SQL Server database from a to b, and then upsize
> the mdb database to SQL Server.
> Unless there is an easier way to transport SQL Server databases including
> views and stored procedures?
> Thanks all
> Simon
>|||Attach, detach does NOT work to copy SQL databases into an access MDB unless
I have really missed the boat... I would probably use DTS and pick sql as
the source and Access as the destination...
--
Wayne Snyder MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
(Please respond only to the newsgroups.)
I support the Professional Association for SQL Server
(www.sqlpass.org)
"Simon Harvey" <simon.harvey@.the-web-works.co.uk> wrote in message
news:#Lik0fo5DHA.2380@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Does anyone happen to know if it is possible to downsize a SQL Server
> database to an Access mdb file? The reason I ask is because I want to use
an
> mdb file to transport the SQL Server database from a to b, and then upsize
> the mdb database to SQL Server.
> Unless there is an easier way to transport SQL Server databases including
> views and stored procedures?
> Thanks all
> Simon
>|||From your question is sounded like you were trying to transfer a database
from one MSSQL server to another using an Access database as the transfer
media. If that is the case then I would ditch using Access and just detach
the database from the source, copy to the destination and re-attach the
database.
Jim
"Wayne Snyder" <wsnyder@.ikon.com> wrote in message
news:uDorHDp5DHA.2300@.TK2MSFTNGP10.phx.gbl...
> Attach, detach does NOT work to copy SQL databases into an access MDB
unless
> I have really missed the boat... I would probably use DTS and pick sql as
> the source and Access as the destination...
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Computer Education Services Corporation (CESC), Charlotte, NC
> (Please respond only to the newsgroups.)
> I support the Professional Association for SQL Server
> (www.sqlpass.org)
> "Simon Harvey" <simon.harvey@.the-web-works.co.uk> wrote in message
> news:#Lik0fo5DHA.2380@.TK2MSFTNGP10.phx.gbl...
> > Hi,
> >
> > Does anyone happen to know if it is possible to downsize a SQL Server
> > database to an Access mdb file? The reason I ask is because I want to
use
> an
> > mdb file to transport the SQL Server database from a to b, and then
upsize
> > the mdb database to SQL Server.
> >
> > Unless there is an easier way to transport SQL Server databases
including
> > views and stored procedures?
> >
> > Thanks all
> >
> > Simon
> >
> >
>