Copy SQL SERVER 2008 database to sql Express 2008

**Cowboy \(Gregory A. Beamer - MVP\)** · Oct 28 '08, 02:55 AM

Re: Copy SQL SERVER 2008 database to sql Express 2008

You can copy the file and attach.
You can backup and then restore.
You can use the Database Publishing wizard.

The first is the fastest.

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

Subscribe to my blog

Stop Making Sense

http://feeds.feedburner.com/GregoryBeamer#

or just read it:

Stop Making Sense

http://feeds.feedburner.com/GregoryBeamer

*************** *************** **************
| Think outside the box! |
*************** *************** **************
"AAaron123" <aaaron123@road runner.comwrote in message
news:uhAreYKOJH A.1164@TK2MSFTN GP02.phx.gbl...

>I need to move a database from sql server 2008 to sql express 2008.
>
Will backing up the sql server 2008 database to a file and then using that
file to restore to sql express 2008 work?
>
I don't have express on my machine so I can't simply try to see if it
works.
>
If I do do it, sql server will be on my machine and sql express will be
remote.
>
>
Thanks
>

**Michael Nemtsev [MVP]** · Oct 28 '08, 09:25 AM

Re: Copy SQL SERVER 2008 database to sql Express 2008

Hello Cowboy (Gregory A. Beamer - MVP),

Can you?!
As I remember if your used enterprize features with your DB you can't easily
attach this DB to previous editions.
I had this issue with SQL enterprize and SQL Express 2005.
Need to export/import first, as I remember.

But it depends on DB and what was already changed

---
WBR,
Michael Nemtsev [Microsoft MVP] :: blog: http://spaces.live.com/laflour
:: http://twitter.com/laflour

"The greatest danger for most of us is not that our aim is too high and we
miss it, but that it is too low and we reach it" (c) Michelangelo

CYou can copy the file and attach.
CYou can backup and then restore.
CYou can use the Database Publishing wizard.
CThe first is the fastest.
C>
CSubscribe to my blog
Chttp://feeds.feedburner.com/GregoryBeamer#
Cor just read it:
Chttp://feeds.feedburner.com/GregoryBeamer
C************** *************** ***************
C| Think outside the box! |
C************** *************** ***************
C"AAaron123" <aaaron123@road runner.comwrote in message
Cnews:uhAreYKOJ HA.1164@TK2MSFT NGP02.phx.gbl.. .

>I need to move a database from sql server 2008 to sql express 2008.
>>
>Will backing up the sql server 2008 database to a file and then using
>that file to restore to sql express 2008 work?
>>
>I don't have express on my machine so I can't simply try to see if it
>works.
>>
>If I do do it, sql server will be on my machine and sql express will
>be remote.
>>
>Thanks
>>

**AAaron123** · Oct 28 '08, 01:35 PM

Re: Copy SQL SERVER 2008 database to sql Express 2008

Database from sql server to sql express is not a problem?

How about using the sql server as a client to the remote sql express?

Thanks

"Michael Nemtsev [MVP]" <nemtsev@msn.co mwrote in message
news:900895ec7a 7898cb0751228f2 ac0@msnews.micr osoft.com...

Hello Cowboy (Gregory A. Beamer - MVP),
>
Can you?! As I remember if your used enterprize features with your DB you
can't easily attach this DB to previous editions.
I had this issue with SQL enterprize and SQL Express 2005. Need to
export/import first, as I remember.
>
But it depends on DB and what was already changed
>
---
WBR, Michael Nemtsev [Microsoft MVP] :: blog:
http://spaces.live.com/laflour :: http://twitter.com/laflour
>
"The greatest danger for most of us is not that our aim is too high and we
miss it, but that it is too low and we reach it" (c) Michelangelo
>
CYou can copy the file and attach.
CYou can backup and then restore.
CYou can use the Database Publishing wizard.
CThe first is the fastest.
CCSubscribe to my blog
Chttp://feeds.feedburner.com/GregoryBeamer#
Cor just read it:
Chttp://feeds.feedburner.com/GregoryBeamer
C************** *************** ***************
C| Think outside the box! |
C************** *************** ***************
C"AAaron123" <aaaron123@road runner.comwrote in message
Cnews:uhAreYKOJ HA.1164@TK2MSFT NGP02.phx.gbl.. .

>>I need to move a database from sql server 2008 to sql express 2008.
>>>
>>Will backing up the sql server 2008 database to a file and then using
>>that file to restore to sql express 2008 work?
>>>
>>I don't have express on my machine so I can't simply try to see if it
>>works.
>>>
>>If I do do it, sql server will be on my machine and sql express will
>>be remote.
>>>
>>Thanks
>>>

>
>

**Cowboy \(Gregory A. Beamer\)** · Oct 28 '08, 02:35 PM

Re: Copy SQL SERVER 2008 database to sql Express 2008

"Michael Nemtsev [MVP]" <nemtsev@msn.co mwrote in message
news:900895ec7a 7898cb0751228f2 ac0@msnews.micr osoft.com...

Hello Cowboy (Gregory A. Beamer - MVP),
>
Can you?!

From SQL 2008 to SQL 2008 Express? Sure. That was the question outlined.

As I remember if your used enterprize features with your DB you can't
easily attach this DB to previous editions.

SQL 2008 uses the 2005 file format, so there is not much problem between
2008 and 2005. There is probably something you can do that 2005 will not
understand.

To test this, I just created a database in 2008, detatched it and attached
to SQL 2005. No problems. For older versions of the database, you have to
set compatibility and will likely have to use the backup and restore method.

I had this issue with SQL enterprize and SQL Express 2005. Need to
export/import first, as I remember.

Backup and restore is often a better option when there is a known
incompatiblity with file types.

But it depends on DB and what was already changed

Certainly. And, worse case, you can always script out the database and then
migrate the data. That is what the Database Publishing Wizard does, in
effect. I would not use the Publishing Wizard for a huge database. It is
designed for intial seed, IMO.

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

Subscribe to my blog

Stop Making Sense

http://feeds.feedburner.com/GregoryBeamer#

or just read it:

Stop Making Sense

http://feeds.feedburner.com/GregoryBeamer

*************** *************** **************
| Think outside the box! |
*************** *************** **************

**Cowboy \(Gregory A. Beamer\)** · Oct 28 '08, 02:35 PM

Re: Copy SQL SERVER 2008 database to sql Express 2008

"AAaron123" <aaaron123@road runner.comwrote in message
news:%23gRqWCQO JHA.1148@TK2MSF TNGP05.phx.gbl. ..

Database from sql server to sql express is not a problem?
>
How about using the sql server as a client to the remote sql express?

You can also set up a Snapshot Replication, although that would be rather
heavy for a single migration effort. :-)

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

Subscribe to my blog

Stop Making Sense

http://feeds.feedburner.com/GregoryBeamer#

or just read it:

Stop Making Sense

http://feeds.feedburner.com/GregoryBeamer

*************** *************** **************
| Think outside the box! |
*************** *************** **************

**AAaron123** · Oct 28 '08, 03:45 PM

Re: Copy SQL SERVER 2008 database to sql Express 2008

I take that to mean the sql client can talk to an sql express.
Thanks a lot

"Cowboy (Gregory A. Beamer)" <NoSpamMgbworld @comcast.netNoS pamMwrote in
message news:O8k9$lQOJH A.3748@TK2MSFTN GP04.phx.gbl...

>
"AAaron123" <aaaron123@road runner.comwrote in message
news:%23gRqWCQO JHA.1148@TK2MSF TNGP05.phx.gbl. ..

>Database from sql server to sql express is not a problem?
>>
>How about using the sql server as a client to the remote sql express?

>
You can also set up a Snapshot Replication, although that would be rather
heavy for a single migration effort. :-)
>
--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA
>
Subscribe to my blog

Stop Making Sense

http://feeds.feedburner.com/GregoryBeamer#

>
or just read it:

Stop Making Sense

http://feeds.feedburner.com/GregoryBeamer

>
*************** *************** **************
| Think outside the box! |
*************** *************** **************