By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,493 Members | 3,101 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,493 IT Pros & Developers. It's quick & easy.

Copy SQL SERVER 2008 database to sql Express 2008

P: n/a
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
Oct 28 '08 #1
Share this Question
Share on Google+
6 Replies


P: n/a
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
http://feeds.feedburner.com/GregoryBeamer#

or just read it:
http://feeds.feedburner.com/GregoryBeamer

********************************************
| Think outside the box! |
********************************************
"AAaron123" <aa*******@roadrunner.comwrote in message
news:uh**************@TK2MSFTNGP02.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
Oct 28 '08 #2

P: n/a
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" <aa*******@roadrunner.comwrote in message
Cnews:uh**************@TK2MSFTNGP02.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

Oct 28 '08 #3

P: n/a
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]" <ne*****@msn.comwrote in message
news:90**************************@msnews.microsoft .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" <aa*******@roadrunner.comwrote in message
Cnews:uh**************@TK2MSFTNGP02.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


Oct 28 '08 #4

P: n/a

"Michael Nemtsev [MVP]" <ne*****@msn.comwrote in message
news:90**************************@msnews.microsoft .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
http://feeds.feedburner.com/GregoryBeamer#

or just read it:
http://feeds.feedburner.com/GregoryBeamer

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

Oct 28 '08 #5

P: n/a

"AAaron123" <aa*******@roadrunner.comwrote in message
news:%2****************@TK2MSFTNGP05.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
http://feeds.feedburner.com/GregoryBeamer#

or just read it:
http://feeds.feedburner.com/GregoryBeamer

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

Oct 28 '08 #6

P: n/a
I take that to mean the sql client can talk to an sql express.
Thanks a lot
"Cowboy (Gregory A. Beamer)" <No************@comcast.netNoSpamMwrote in
message news:O8**************@TK2MSFTNGP04.phx.gbl...
>
"AAaron123" <aa*******@roadrunner.comwrote in message
news:%2****************@TK2MSFTNGP05.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
http://feeds.feedburner.com/GregoryBeamer#

or just read it:
http://feeds.feedburner.com/GregoryBeamer

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

Oct 28 '08 #7

This discussion thread is closed

Replies have been disabled for this discussion.