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 |
|
john.burns
Posting Yak Master
100 Posts |
 Posted - 2008-04-07 : 09:14:45
|
| All,Does anyone have amethod for copying db(all tables, procs etc..) but without the data. Scripting is not feasible because of number of objects constraints ..etc...any help would be appreciated thanks,JB |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-07 : 09:24:28
|
| Look at SSIS packages in BIDs,they have control-flow task for it. |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2008-04-07 : 11:10:26
|
| I don't know about the SSIS-deal but if you don't want to script out everything, the way I probably would go is restore from an fresh backup and then delete the data you don't need.--Lumbago"SELECT Rum, Coke, Lime, Ice FROM bar WHERE ClosingTime = 'Late' AND FemaleMaleRatio > 4" |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-07 : 11:12:55
|
| That is not a good idea. |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2008-04-07 : 11:18:33
|
| I'd say it depends on the mass of data...--Lumbago"SELECT Rum, Coke, Lime, Ice FROM bar WHERE ClosingTime = 'Late' AND FemaleMaleRatio > 4" |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-07 : 11:45:56
|
| Look at Transfer SQL server object Tasks in SSIS BIDS. |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2008-04-07 : 11:51:40
|
| SSIS is the best way of doing it after scripting, IMO. |
|
|
|
|
|
|
Copy db w/o data