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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-12-08 : 08:19:12
|
| Tom writes "I'm working on a project where we allow the user to create a subset of data within various tables of of three databases. Three databases that make up a 'set'. The user selects desired items from the master set to create their 'set'. That 'set' will then be used for testing and production uses by an already written app.In my idea phase I've thought of doing a backup and restore followed by removing the items (records) the user hasn't selected for this 'set' would be deleted. That was the first idea. The second idea was to do a dts package to copy the master set databases and do the delete of the non-selected items.I'm open to any ideas you might have. If this is too vague I do apologize. However, I can't discuss the specifics due to security restraints.ThanksSQL 2K SP3Windows Server 2003 Stdand a partridge in a pear tree :)" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-09 : 01:25:03
|
| Did you mean Table Level backup/Restore?Give more detailsMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Database copying