Timeline for Looking for a utility to move data between databases (prod to dev) SQL Server 2012 [closed]
Current License: CC BY-SA 3.0
17 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 26, 2015 at 14:52 | history | closed |
Paul White♦ Philᵀᴹ Hannah Vernon♦ Aaron Bertrand |
Not suitable for this site | |
| Jan 24, 2015 at 0:42 | review | Close votes | |||
| Jan 26, 2015 at 14:52 | |||||
| Jul 10, 2014 at 20:35 | history | edited | Dan Ribar | CC BY-SA 3.0 |
added 237 characters in body
|
| Jul 10, 2014 at 16:46 | comment | added | billinkc | SSIS can be a snap if it's a straight copy. See my answer here | |
| Jul 10, 2014 at 15:57 | answer | added | Mike A | timeline score: 0 | |
| Jul 9, 2014 at 14:35 | history | tweeted | twitter.com/#!/StackDBAs/status/486881374339878912 | ||
| Jul 9, 2014 at 14:21 | answer | added | Shanky | timeline score: 3 | |
| S Jul 9, 2014 at 14:20 | history | suggested | James Anderson |
added ssis and migration tags
|
|
| Jul 9, 2014 at 14:20 | comment | added | Aaron Bertrand | That's what data compare does - you can review the comparisons if you want, but just click the GO button and it makes the destination data look exactly like the source data. | |
| Jul 9, 2014 at 14:19 | comment | added | Dan Ribar | I actually just downloaded SQL data compare as an option, but I really don't need to compare -- I just want to copy all the data so dev looks like prod from a data perspective. I ran the compare on three tables that had a couple hundred thousand records and it was a slowwwww process so I ruled it out. Thanks for the thoughts. | |
| Jul 9, 2014 at 14:12 | review | Suggested edits | |||
| S Jul 9, 2014 at 14:20 | |||||
| Jul 9, 2014 at 14:10 | comment | added | Hannah Vernon♦ | Idera SQL Comparison Toolkit - idera.com/productssolutions/sqlserver/sqlcomparisontoolset | |
| Jul 9, 2014 at 14:09 | comment | added | Thomas Stringer | SSIS would still get my vote. You could always write your own script (with PowerShell, for example) but that's more work than necessary. That's a very simple task with SSIS. | |
| Jul 9, 2014 at 14:07 | history | edited | marc_s | CC BY-SA 3.0 |
added 1 character in body; edited title
|
| Jul 9, 2014 at 14:05 | comment | added | Aaron Bertrand | Red Gate SQL Compare & SQL Data Compare | |
| Jul 9, 2014 at 14:05 | answer | added | Kin Shah | timeline score: 0 | |
| Jul 9, 2014 at 14:01 | history | asked | Dan Ribar | CC BY-SA 3.0 |