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 |
|
gaby_58
Starting Member
33 Posts |
 Posted - 2012-06-04 : 10:42:45
|
| Hi all, I would like to copy some of production data to test database and just wondering how do I do that, Can I use SSIS. currently we have test data available and that is not a very good test data, so I want to get new test data and update that way testing can be done more accurately. Thanks for any suggestions and tips |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-06-04 : 12:38:17
|
| you can use1. export import wizard2. OPENROWSET if its for one time adhoc3. linked server and use OPENQUERY or four part naming convention------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
gaby_58
Starting Member
33 Posts |
Posted - 2012-06-04 : 15:35:42
|
| Thanks for the reply, want to know I already have some data in Test DB, so When I do export and import, will it not overwrite. Also can I restrict dat I need to export depending on the date? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-06-04 : 16:42:19
|
quote:
Originally posted by gaby_58
Thanks for the reply, want to know I already have some data in Test DB, so When I do export and import, will it not overwrite. Also can I restrict dat I need to export depending on the date?
nope..you can specify in settings to append dataYep...you can restrict data depending on date by choosing a query as source rather than straight pull in export import wizard settings------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
How to copy production data to test data