October 10, 2008 at 8:04 am
Is anyone knows how to copy loggins from one server to another, jobs, store procedures, maintance jobs.
October 10, 2008 at 8:32 am
You can script all of those by right-clicking on them in Object Explorer of SSMS and selecting "Script as". If you want to script out multiple objects of the same type, click on the folder level to list them all in the Object Explorer Details pane then highlight the ones you want and right-click.
The scripts generated can then be run in a query window of the instance where you want to move them.
Greg
October 10, 2008 at 8:41 am
To move logins, get sp_help_revlogin from Microsoft, which will script out the logins with the same password.
October 10, 2008 at 10:35 am
There are functions to do most all of this in SSIS
October 10, 2008 at 11:10 am
If available, do it in SSIS.
October 10, 2008 at 11:29 am
Under which database I need to run
October 10, 2008 at 11:30 am
What is SSMS
October 10, 2008 at 11:43 am
Sorry, this is not what I wanted to type. What happends if SSIS is not available. Thank you
October 10, 2008 at 12:29 pm
Yulia, do you have Business Intelligence Development Studio in your SQL Server installation ?
Do you have Visual Studio for same version as your SQL Server ?
October 11, 2008 at 11:41 am
Just script them as Greg said in reply #1!!! :crazy:
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.October 13, 2008 at 9:17 am
Thank you
October 13, 2008 at 12:48 pm
Thank you, I get copy of my logins but password is not correct, any idea why?
October 13, 2008 at 12:49 pm
I have Visual Studio
October 13, 2008 at 1:58 pm
where do I run sp_help_revlogin
October 14, 2008 at 7:39 am
This works.Thank you so much
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply