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 |
|
john.burns
Posting Yak Master
100 Posts |
 Posted - 2007-02-06 : 15:01:10
|
| I am migrating a sql server from test to prod by copying the datadirectory over and modifying sysserver system table. I know thisworks nicely but does anyone know if I can to this when source serveris running Standard Edition and Target Server is running Enterprise edition.thank you |
|
|
propanecan
Yak Posting Veteran
60 Posts |
Posted - 2007-02-06 : 15:27:04
|
| This isn't a method I'm familiar with. It sounds like you don't have another Enterprise edition server other than your prod server to test with? What about using a detach/attach or backup/restore method? |
 |
|
|
john.burns
Posting Yak Master
100 Posts |
Posted - 2007-02-06 : 15:36:23
|
| trying to save time recreating logins and jobs but detach is probably safer. thanks |
|
|
|
propanecan
Yak Posting Veteran
60 Posts |
Posted - 2007-02-06 : 15:43:52
|
| I would suggest scripting your logins and jobs. That should speed up the process. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-06 : 16:16:26
|
| The easiest way to move databases from one server to another without having to worry about logins, jobs, DTS packages, etc... is to install SQL Server on the target server using the same paths as the source server. Then you can simply stop the SQL Server service on both machines, copy all MDFs, NDFs, LDFs for all databases (including system ones) to the same path on the target server, then start the SQL Server service on the target server.I've used this method several times successfully. Using this method copies all logins, jobs, DTS packages, etc... as you brought over the databases that contained this data.Tara Kizer |
|
|
|
john.burns
Posting Yak Master
100 Posts |
Posted - 2007-02-08 : 14:04:11
|
| Yes, I've done this as well. but in this case I was going fromstandard edtion on source to enterprise edition on target. I tried it and all looked o.k. but I decided not to risk problems and did it the hard way (bit by bit).thanks |
|
|
|
|
|
|
Move to another server