Red Gate forums :: View topic - What's the proper way of setting up staging?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare Previous Versions
SQL Compare Previous Versions forum

What's the proper way of setting up staging?

Search in SQL Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
kulmam92



Joined: 03 Dec 2011
Posts: 7

PostPosted: Sat Dec 03, 2011 11:10 am    Post subject: What's the proper way of setting up staging? Reply with quote

I watched the "SQL Server Central Webinar Series #11: A Sandbox Development Process Using SQL Source Control and SQL Virtual Restore" and red-gate product seems like really good tool.
In that webinar the following environments are mentioned. I have some question about setting up each environment

1. sendbox
virtual restore looks like really promising but how does it work when I update big amount of data or add column with default value to the big table? Will the duration be the same as normal database?
2. shared server
3. QA
4. staging
what's do proper way of setting up staging?
It looks like it should be a exact same copy of production but does this mean that it should have same data as production? If so, how can I set up that environment? Should I restore a backup of production every night?
5. production
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6671

PostPosted: Mon Dec 05, 2011 4:18 pm    Post subject: Reply with quote

Hi Kulmam,

This forum is primarily for issues about the SQL Compare software, so we really don't offer these kinds of solutions. I think you would get a better response from the person who presented the webinar. There is a forum for Q&A especially about this webinar that you can post to on the SQL Server Central website: http://www.sqlservercentral.com/Forums/Topic1147777-83-1.aspx

I think you will get solid answers to your questions there.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group