Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chedderslam
Posting Yak Master
223 Posts |
 Posted - 2011-01-18 : 14:17:48
|
| I cannot use the copy db wizard because express doesn't have agent.I cannot make a back up and restore as they are different versions.I tried using the db publishing wizard but it is taking way to long.Any ideas? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-01-18 : 14:39:44
|
| Script out all of the objects and apply the scripts against SQL Express.BCP all of the data out to flat files.Bulk Insert all of the data files into SQL Express.Remember that there is a 4GB limit on database size in Express. |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-01-18 : 16:37:13
|
| Providing you're going up-version (2005-2008 or 2005-2008 R2) you can use backup/restore.--Gail ShawSQL Server MVP |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-01-18 : 16:57:38
|
| What version are you backing up from, and what version are you trying to restore to? Yes, if you are trying to backup from a 2008 instance and restore to a 2005 instance that won't work.Since you are working with the Express Edition, could you not install the appropriate Express Edition and restore to that instance?Jeff |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-01-18 : 20:32:48
|
quote:
Originally posted by GilaMonster
Providing you're going up-version (2005-2008 or 2005-2008 R2) you can use backup/restore.--Gail ShawSQL Server MVP
Yep. I misread it/assumed OP was downgrading. |
|
|
|
|
|
|
best way to copy 2005 db to express