<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server 2008 - General
»
Keeping all three environment(Dev,Stag,Prod)...
22 posts, Page 1 of 3
1
2
3
»
»»
Keeping all three environment(Dev,Stag,Prod) in sync
Rate Topic
Display Mode
Topic Options
Author
Message
wannalearn
wannalearn
Posted Wednesday, December 26, 2012 3:38 PM
SSC Rookie
Group: General Forum Members
Last Login: Tuesday, March 05, 2013 9:45 AM
Points: 39,
Visits: 83
In our office we run jobs to keep these environment in sync. We get data from outside source and run the job overnight to load data on Prod. It's not a big environment so we have managed to do back up and restore on other environment as per need basis.
I am assigned to find out better way to keep them in sync. I have googled on this topic and I am lost right now.
Plz advise.
Post #1400400
SatishAyyar
SatishAyyar
Posted Wednesday, December 26, 2012 3:50 PM
SSC-Addicted
Group: General Forum Members
Last Login: Yesterday @ 10:06 PM
Points: 479,
Visits: 410
You can use Replication.
http://www.sqlservercentral.com/stairway/72401/
Post #1400401
@SQLFRNDZ
@SQLFRNDZ
Posted Wednesday, December 26, 2012 3:57 PM
SSC-Addicted
Group: General Forum Members
Last Login: Friday, June 14, 2013 4:19 PM
Points: 412,
Visits: 872
wannalearn (12/26/2012)
In our office we run jobs to keep these environment in sync. We get data from outside source and run the job overnight to load data on Prod. It's not a big environment so we have managed to do back up and restore on other environment as per need basis.
I am assigned to find out better way to keep them in sync. I have googled on this topic and I am lost right now.
Plz advise.
The best way is Logshipping depends on the daily load though...
If it is huge load every day then go for creating a SSIS package to refresh teh dB in test and other region using Auto sql job.
--
SQLFRNDZ
Post #1400403
Jeff Moden
Jeff Moden
Posted Wednesday, December 26, 2012 4:04 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 5:19 PM
Points: 33,110,
Visits: 27,035
@SQLFRNDZ (12/26/2012)
The best way is Logshipping depends on the daily load though...
Not really. "It Depends". SAN-based replication is nearly instantaneous and puts no load on the production server. It has some disadvantages but, like I said, "It Depends". Hell would have to freeze over and pigs would have to grow wings before I'd ever consider using SSIS for such a thing.
--Jeff Moden
"
RBAR
is pronounced "ree-bar" and is a "Modenism" for "
R
ow-
B
y-
A
gonizing-
R
ow".
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1400405
@SQLFRNDZ
@SQLFRNDZ
Posted Wednesday, December 26, 2012 4:29 PM
SSC-Addicted
Group: General Forum Members
Last Login: Friday, June 14, 2013 4:19 PM
Points: 412,
Visits: 872
Jeff Moden (12/26/2012)
@SQLFRNDZ (12/26/2012)
The best way is Logshipping depends on the daily load though...
Not really. "It Depends". SAN-based replication is nearly instantaneous and puts no load on the production server. It has some disadvantages but, like I said, "It Depends". Hell would have to freeze over and pigs would have to grow wings before I'd ever consider using SSIS for such a thing.
Sounds Good but SAN-Based replication supports specific to 1 dB ?
My understanding that his requirement is not DR and he just wants to copy a database to other lower environments daily and want to automate the process. SAN-replication sounds to me like mirroring the environment instead just a dB.
--
SQLFRNDZ
Post #1400411
Jeff Moden
Jeff Moden
Posted Thursday, December 27, 2012 8:34 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 5:19 PM
Points: 33,110,
Visits: 27,035
@SQLFRNDZ (12/26/2012)
Jeff Moden (12/26/2012)
@SQLFRNDZ (12/26/2012)
The best way is Logshipping depends on the daily load though...
Not really. "It Depends". SAN-based replication is nearly instantaneous and puts no load on the production server. It has some disadvantages but, like I said, "It Depends". Hell would have to freeze over and pigs would have to grow wings before I'd ever consider using SSIS for such a thing.
Sounds Good but SAN-Based replication supports specific to 1 dB ?
My understanding that his requirement is not DR and he just wants to copy a database to other lower environments daily and want to automate the process. SAN-replication sounds to me like mirroring the environment instead just a dB.
It depends on the SAN and either the software or the hardware they built in to it. At the current company I work for, we use it to replicate the entire environment offsite for DR purposes on a continual basis. At a previous company, we used it once at day at midnight to replicate the main prod database to a reporting/analysis DB. Total "offline" time was less than 15 seconds for that.
--Jeff Moden
"
RBAR
is pronounced "ree-bar" and is a "Modenism" for "
R
ow-
B
y-
A
gonizing-
R
ow".
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1400639
wannalearn
wannalearn
Posted Thursday, December 27, 2012 9:06 AM
SSC Rookie
Group: General Forum Members
Last Login: Tuesday, March 05, 2013 9:45 AM
Points: 39,
Visits: 83
Thank you all for your responses.
We can not use Log Shipping because Our databases do not store transactions. We load data everynight from different sources . So it is not our responsibility right now.
We use replication but only for some database. My senior DBA has not kept all databases in sync for some reason. it could be hardware issues.
This is exactly what we want as mentioned by @SQLFRNDZ - "his requirement is not DR and he just wants to copy a database to other lower environments daily and want to automate the process."
Is there any efficient way other than back up and restore ?
Thanks!
Post #1400663
SatishAyyar
SatishAyyar
Posted Thursday, December 27, 2012 10:18 AM
SSC-Addicted
Group: General Forum Members
Last Login: Yesterday @ 10:06 PM
Points: 479,
Visits: 410
I would run the same process, that loads data into production, on the lower environments. For example if you have a SSIS package which loads data into production. Create a copy of this SSIS package and point the connections to lower environments and run the package manually or just schedule it. That way you don't have to take backup and do the restore.
Post #1400697
wannalearn
wannalearn
Posted Friday, December 28, 2012 8:07 AM
SSC Rookie
Group: General Forum Members
Last Login: Tuesday, March 05, 2013 9:45 AM
Points: 39,
Visits: 83
Thanks Satish! I am not sure if we can use SSIS package at this time. I am trying to understand the process in details . Will come back for some more queries.
Post #1400928
John Mitchell-245523
John Mitchell-245523
Posted Friday, December 28, 2012 8:25 AM
SSCarpal Tunnel
Group: General Forum Members
Last Login: Tuesday, June 04, 2013 7:03 AM
Points: 4,443,
Visits: 7,249
wannalearn (12/28/2012)
Thanks Satish! I am not sure if we can use SSIS package at this time. I am trying to understand the process in details . Will come back for some more queries.
SSIS was just an example that Satish gave. Since you say that all your data comes from outside, just use exactly the same process that you use to load data into Prod to load it into the other two environments.
John
Post #1400935
« Prev Topic
|
Next Topic »
22 posts, Page 1 of 3
1
2
3
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
