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
> >
> >
>

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...

quote:

---

> 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

quote:

---

> 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...

quote:

---

> 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

quote:

---

> 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...

quote:

---

> 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

quote:

---

> 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...

quote:

---

> Attach, detach does NOT work to copy SQL databases into an access MDB

---

unless

quote:

---

> 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...
use[QUOTE]
> an
upsize[QUOTE]
including[QUOTE]
>

---

Downsize from SQL Server to MSDE?

We recommend that our clients install SQL Server at each of their satellite
offices. Every night we DTS the central database out to the satellite
offices. That way, if the link goes down, or if the main server were to go
down, we'd have one or more backup databases to switch over to.
One client is looking to save on SQL Server licensing costs. They understand
that the main server will need to be SQL Server, but they're reluctant to
pay extra for additional servers which won't normally be used. They're
asking if they could have MSDE installed at the satellite offices, rather
than SQL Server, and is there any way the main SQL Server database can be
pumped down to the satellite MSDE databases nightly. Is this possible with
DTS or any other way?
If you have any suggestions or reference links, that would be very much
appreciated!
Thanks,
- Joe Geretz -
As long as the MSDE installation does not violate Microsoft's EULA for MSDE
or the database is not greater than 2GB in size or the usage of the MSDE
instances will not be hampered by the built in processing governor in MSDE,
then I would see no problem.
Jim
"Joseph Geretz" <jgeretz@.nospam.com> wrote in message
news:ulI7Pp3FEHA.712@.tk2msftngp13.phx.gbl...
> We recommend that our clients install SQL Server at each of their
satellite
> offices. Every night we DTS the central database out to the satellite
> offices. That way, if the link goes down, or if the main server were to go
> down, we'd have one or more backup databases to switch over to.
> One client is looking to save on SQL Server licensing costs. They
understand
> that the main server will need to be SQL Server, but they're reluctant to
> pay extra for additional servers which won't normally be used. They're
> asking if they could have MSDE installed at the satellite offices, rather
> than SQL Server, and is there any way the main SQL Server database can be
> pumped down to the satellite MSDE databases nightly. Is this possible with
> DTS or any other way?
> If you have any suggestions or reference links, that would be very much
> appreciated!
> Thanks,
> - Joe Geretz -
>

Downsize from SQL Server to MSDE?

We recommend that our clients install SQL Server at each of their satellite
offices. Every night we DTS the central database out to the satellite
offices. That way, if the link goes down, or if the main server were to go
down, we'd have one or more backup databases to switch over to.
One client is looking to save on SQL Server licensing costs. They understand
that the main server will need to be SQL Server, but they're reluctant to
pay extra for additional servers which won't normally be used. They're
asking if they could have MSDE installed at the satellite offices, rather
than SQL Server, and is there any way the main SQL Server database can be
pumped down to the satellite MSDE databases nightly. Is this possible with
DTS or any other way?
If you have any suggestions or reference links, that would be very much
appreciated!
Thanks,
- Joe Geretz -
As long as the MSDE installation does not violate Microsoft's EULA for MSDE
or the database is not greater than 2GB in size or the usage of the MSDE
instances will not be hampered by the built in processing governor in MSDE,
then I would see no problem.
Jim
"Joseph Geretz" <jgeretz@.nospam.com> wrote in message
news:ulI7Pp3FEHA.712@.tk2msftngp13.phx.gbl...
> We recommend that our clients install SQL Server at each of their
satellite
> offices. Every night we DTS the central database out to the satellite
> offices. That way, if the link goes down, or if the main server were to go
> down, we'd have one or more backup databases to switch over to.
> One client is looking to save on SQL Server licensing costs. They
understand
> that the main server will need to be SQL Server, but they're reluctant to
> pay extra for additional servers which won't normally be used. They're
> asking if they could have MSDE installed at the satellite offices, rather
> than SQL Server, and is there any way the main SQL Server database can be
> pumped down to the satellite MSDE databases nightly. Is this possible with
> DTS or any other way?
> If you have any suggestions or reference links, that would be very much
> appreciated!
> Thanks,
> - Joe Geretz -
>
sql

Downsize from SQL Server to MSDE?

We recommend that our clients install SQL Server at each of their satellite
offices. Every night we DTS the central database out to the satellite
offices. That way, if the link goes down, or if the main server were to go
down, we'd have one or more backup databases to switch over to.
One client is looking to save on SQL Server licensing costs. They understand
that the main server will need to be SQL Server, but they're reluctant to
pay extra for additional servers which won't normally be used. They're
asking if they could have MSDE installed at the satellite offices, rather
than SQL Server, and is there any way the main SQL Server database can be
pumped down to the satellite MSDE databases nightly. Is this possible with
DTS or any other way?
If you have any suggestions or reference links, that would be very much
appreciated!
Thanks,
- Joe Geretz -As long as the MSDE installation does not violate Microsoft's EULA for MSDE
or the database is not greater than 2GB in size or the usage of the MSDE
instances will not be hampered by the built in processing governor in MSDE,
then I would see no problem.
Jim
"Joseph Geretz" <jgeretz@.nospam.com> wrote in message
news:ulI7Pp3FEHA.712@.tk2msftngp13.phx.gbl...
> We recommend that our clients install SQL Server at each of their
satellite
> offices. Every night we DTS the central database out to the satellite
> offices. That way, if the link goes down, or if the main server were to go
> down, we'd have one or more backup databases to switch over to.
> One client is looking to save on SQL Server licensing costs. They
understand
> that the main server will need to be SQL Server, but they're reluctant to
> pay extra for additional servers which won't normally be used. They're
> asking if they could have MSDE installed at the satellite offices, rather
> than SQL Server, and is there any way the main SQL Server database can be
> pumped down to the satellite MSDE databases nightly. Is this possible with
> DTS or any other way?
> If you have any suggestions or reference links, that would be very much
> appreciated!
> Thanks,
> - Joe Geretz -
>