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 |
|
pelegk2
Aged Yak Warrior
723 Posts |
 Posted - 2005-10-11 : 05:15:11
|
| how do i export the sql server including its jobs,stored procedure,users and all the datatbases that i have created so i can impor them on another serverthnaks in advancepelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-10-11 : 05:40:04
|
| Blimey pelegk2, are we going to do all your work for you, or are you going to read up and Google the basics?No offence intended, but this feels like the kids who arrive here posting their Homework questions and expecting a worked answer in return!"I've tried this and it didn't work" or "We need to move SProcs, Users, Permissions and Jobs from DEV to PRODUCTION - what routes are open to us" are more the sort of question I prefer answering.For example, you can script the database to get the Sprocs, Users and their permissions. Jobs is a bit more difficult. If you are doing this to move from DEV to PRODUCTION then it should have been part of your company's strategy during the development, and considering it now is late in the process. But if its for a different purpose then knowing what that "problem/scenario" is would probably enable me, and other folk here, to give you better suggestions.Kristen |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-10-11 : 12:53:34
|
| Hey Kristen, I've scripted Jobs too just fine, although the script needed some slight editing, it wasn't too bad.---------------------------EmeraldCityDomains.com |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-10-11 : 12:55:23
|
| peleg, if you go to our Home page on the top left you'll see a listing of Topics about which we have a LOT of articles to help you get started. You might want to browse some of those.---------------------------EmeraldCityDomains.com |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
|
|
exporting all ofthe sql server