September 8, 2010 at 1:40 pm
Hi,
I want to move(migrate) from Development to production server. I'm developing the database for reporting services. So now I want to put it into production .How can I do that ?
Thanks
September 8, 2010 at 2:04 pm
If the database is empty just script it out and all the objects/users and permissions and run the scripts in production.
If the DB contains data the easiest way is to backup the database and restore it to the production server, moving the data and/or log files as needed.
The probability of survival is inversely proportional to the angle of arrival.
September 8, 2010 at 2:13 pm
You can also do a backup/restore or detach/attach on the production server, but be sure that it's what you really want to move.
There are also compare tools, like SQL Compare and Data Compare from Red Gate Software (my employer) that will make this easy. Apex and Idera sell similar tools, all of which will work.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
September 15, 2010 at 11:45 pm
Dear Friends,
if you are hesitating working in production
Please follow below steps ....
if your database is empty and you want to create fresh db
1.) Create a db in your local machine and run all the scripts (schema, triggers, permissions etc) in case of any problem or facing any issue while executing the scripts. you can take a one more chance because you are working on your local.
2.) Once you create the db in local successfully then take a back and restore in production
3.) After that just check db users should be exist in SQL sever under security
if you have data in your database then just follow the 2nd and 3rd steps
In case of any question please feel free to ask
Varinder Sandhu,
http://www.varindersandhu.in/
September 16, 2010 at 1:10 am
I think sturner had replied the same above.
"More Green More Oxygen !! Plant a tree today"
September 22, 2010 at 6:20 am
sturner (9/8/2010)
If the database is empty just script it out and all the objects/users and permissions and run the scripts in production.
Even if the database isn't empty, you can still script it, the users, and the objects out without bringing along development data.
I recommend implementing some sort of Source Control, though, so you can track changes and go back to previous schema and object versions if the new ones don't work. Team Foundation Server, Visual Source Safe, or something similar.
September 22, 2010 at 8:38 am
just make sure the database(s) that you are trying to move to production are not the reportserver and reportservertemp databases. Doing that will wreck your production reporting services configuration.
September 22, 2010 at 10:19 am
fenwicc (9/22/2010)
just make sure the database(s) that you are trying to move to production are not the reportserver and reportservertemp databases. Doing that will wreck your production reporting services configuration.
Excellent point!!!
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply