Showing posts with label SQL Server Agent. Show all posts
Showing posts with label SQL Server Agent. Show all posts

Wednesday, August 29, 2018

You now have SQL Server Agent in SQL Operations Studio

SQL Operations Studio is the lightweight tool to carry out administrative tasks on a SQL Server Instance. SQL Server Agent is a tool in SQL Server Management Studio that does a lot of work created as Jobs.

In the July 2018 Preview, Microsoft has introduced SQL Server Agent by way of an extension so that SQLOPS can be used to work with SQL Server Agent without using the SQL Server Management Studio making it a lot easier and productive.

You can install the July 2018 version needed as shown here:
https://hodentekmsss.blogspot.com/2018/08/install-latest-version-of-sql.html

You can work with SQL Server Agent by installing the extension as shown here:


Wednesday, February 13, 2008

Effortless migration of data from SQL Server 2005 to SQL Server 2008

It's so easy to transfer a database from SQL Server 2005 to SQL Server 2008. Well the same holds good from SQL Server 2000 to SQL Server 2008. Read on...

Moving database from SQL Server 2005 to SQL Server 2008 in three steps

SQL Server 2005 can be migrated to SQL Server 2008 quite easily by manually detaching the database from SQL Server 2005 and attaching it to SQL Server 2008. This is a much easier process than the 'Copy Database Wizard' which has two procedures one of which is the same as the manual process but carried out under the watchful guidance of a wizard and the other which does not require the stopping of the Source server.
DMCA.com Protection Status