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 |
|
suman.reddy39
Starting Member
34 Posts |
 Posted - 2008-07-18 : 09:13:06
|
| Dear all, i need a small help,i got two data bases 1 & 2 in which i have the same data.from 1 of the two data bases, i lost full data from '1'. i didnt maintaine scripts (creata and insert). now is there any process so that i can generate the create and insert scripts accordingly from my database '2'.please help me in this regards.thank you in advance...Don't go the way Life takes you, Take the Life the way you gosubbi |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-18 : 09:16:45
|
| What do you mean? Do you want only structure or data as well? You can go Database 2 - Tasks -generate scripts. |
 |
|
|
suman.reddy39
Starting Member
34 Posts |
Posted - 2008-07-18 : 09:51:11
|
| i need data with structure.but im getting some errors when im going with task- generate scripts.Don't go the way Life takes you, Take the Life the way you gosubbi |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-18 : 09:52:49
|
| Then backup and restore with different name.Restore with move option . |
|
|
|
suman.reddy39
Starting Member
34 Posts |
Posted - 2008-07-18 : 12:19:57
|
| sorry i need with out data in that db.and i tried with task-insert scriptsDon't go the way Life takes you, Take the Life the way you gosubbi |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-18 : 12:31:20
|
quote:
Originally posted by suman.reddy39
i need data with structure.but im getting some errors when im going with task- generate scripts.Don't go the way Life takes you, Take the Life the way you gosubbi
How come you get error?goto database -task- generate script |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-19 : 13:25:52
|
| >> i need with out data in that db.Then you can restore db2's backup as db1 and truncate all tables in db1, if you really can't make script work. |
|
|
|
|
|
|
DataBase Scripts