Tips
MySQL to SQL Server Conversion Tutorial
From time to time companies initiate projects to move from one database platform to another. Such migrations can involve switching between database engines such as SQL Server, MySQL, Oracle, Sybase, DB2, etc. In this tutorial we will explore the differences between MySQL and Microsoft SQL Server and the key components that you should be aware of when making that move.
Overview of Microsoft SQL Server 2008 Upgrade Advisor
Like most organizations, we are planning to upgrade our database server from SQL Server 2005 to SQL Server 2008. I would like to know is there an easy way to know in advance what kind of issues one may encounter when upgrading to a newer version of SQL Server? One way of doing this is to use the Microsoft SQL Server 2008 Upgrade Advisor to plan for upgrades from SQL Server 2000 or SQL Server 2005. In this tip we will take a look at how one can use the SQL Server 2008 Upgrade Advisor to identify potential issues before the upgrade.
Speed up the SQL Server 2005 migration process
For small databases the in place, Copy Database Wizard, Backup\Restore and Detach\Attach database are all viable migration options, but for very large databases (VLDB) the time can be extensive. One twist on the Backup\Restore approach is to use one of the specialized SQL Server backup products.
SQL Server 2005 Upgrade Considerations for DBAs and Developers
Making the decision to upgrade to SQL Server 2005 should be one that is made with sufficient information, not haphazardly. Understanding the changes needed to your SQL Server 2000 environment prior to upgrading should be one of the first sets of information gathered to determine the level of effort needed to upgrade. Scanning your code for issues, reviewing your configurations and DTS Packages can be a time consuming process. As such, how can I gather the needed information about my SQL Server 2000 environment to determine how much work I have to complete before upgrading to SQL Server 2005?
SQL Server 2008 R2 Upgrade Failure due to Security Group upgrade rule
Last month I was working on a SQL Server 2005 to SQL Server 2008 R2 upgrade. Unfortunately, we were not able to complete our upgrade because of a failing a upgrade rule named "Security Group SID (Security Identifier)". The SQL Server Upgrade Setup Wizard did not enable the 'Next' button in order to proceed with the upgrade until this failure was resolve. In this tip, I will describe the reason for this failure and how I fixed the issue in order to have a successful upgrade.
SQL Server 2008 Upgrade Plan for DBAs
At our organization we are in the planning stages of upgrading to SQL Server 2008. What are some of the key considerations as we plan to upgrade? How much time should be spent on planning? Who should do the planning? As a DBA, what are the technical aspects I should research? What is the best way to manage the project?
SQL Server 2008 Upgrade Testing at the Microsoft Technology Center
It has been a year since SQL Server 2008 was launched and like many other companies, my company is also trying to upgrade all the major production database servers from SQL Server 2000 to SQL Server 2008. In order to build a more accurate Project Plan, we wanted to quickly find out if our application will perform acceptably after the upgrade and also make sure we conduct our due diligence. How can we go about taking these steps to ensure we have a smooth upgrade process?
SQL Server Consolidation Pros and Cons
In the recent years, there have been a few different trends related to the hardware platform for SQL Server. One trend was to have a dedicated SQL Server for each application. This trend has been countered in some organizations by a major consolidation effort. The consolidation effort in some circumstances consists of consolidating the hardware and storage to a unified set of devices although the same number of logical machines exists. In other circumstances, the consolidation is for the hardware, storage, Windows and SQL Server instances. Both alternatives have advantages and disadvantages, so what is the correct path? What should organizations follow? What are the SQL Server 2005 and/or 2008 considerations?
SQL Server Migration Assistant 2008 SSMA
One of my client’s requirements is to migrate and consolidate his company departments’ databases to SQL Server 2008. As I know the environment, they are using MySQL , MS-Access and SQL Server with different applications. Now the company has decided to have a single dedicated SQL Server 2008 database server to host all the applications. So there are a few things to do to upgrade and migrate from MySQL and MS-Access to SQL Server 2008. For the migration task, I found the SQL Server Migration Assistant 2008 (SSMA 2008) is very useful which reduces the effort and risk of migration. So in this tip, I will do an overview of SSMA 2008.
Transition from MS Access to SQL Server with the Migration Assistant
Our topic of this tip is going to be transitioning from being an Access Power User into a role of SQL Server Professional.
Upgrading SQL Server databases and changing compatibility levels
When upgrading databases from an older version of SQL Server using either the backup and restore method or detach and attach method the compatibility level does not automatically change and therefore your databases still act as though they are running using an earlier version of SQL Server. From an overall standpoint this is not a major problem, but there are certain features that you will not be able to take advantage of unless your database compatibly level is changed. This tip will show you how to check the current compatibly level, how to change the compatibly level and also some of the differences between earlier versions and SQL Server 2005.
Upgrading to SQL Server 2008 Using Backup and Restore Method
Like any organization, we are also planning the migration of a database from SQL Server 2005 to SQL Server 2008. As there is only one database which needs to be migrated as of now, I think it would be ideal to use the database backup and restore method to upgrade the user database from SQL Server 2005 to SQL Server 2008. In this tip we will go through a detailed explanation of how to use the database backup and restore method to upgrade a database.
Upgrading to SQL Server 2008 using Copy Database Wizard
As like in any organization we are also planning the migration of databases from SQL Server 2005 to SQL Server 2008. As there is only one database which needs to be migrated as of now, I think it would be ideal to use the Copy Database Wizard as it is best suited for such a scenario. Can you give us a detailed explanation of how to use the Copy Database Wizard to upgrade a database?
Upgrading to SQL Server 2008 Using Detach and Attach Operations
Like most other organization, we are planning the migration of a database from SQL Server 2005 to SQL Server 2008. As there is only one database which needs to be migrated as of now, I think it would be ideal to use the detach and attach operation to upgrade the user database from SQL Server 2005 to SQL Server 2008. In this tip we will go through a detailed explanation of how to use the detach and attach operation to upgrade a database.
Version and Edition Upgrades with SQL Server 2008 R2
In most environments there may be a need to do an in place version or edition upgrade for an existing SQL Server installation. Microsoft makes this easy using the Edition Upgrade feature and in this tip we walk through the steps on how to do an upgrade to SQL Server 2008 R2 using this feature.
Why Upgrade to SQL Server 2008
With the recent release of SQL Server 2008, getting up to speed on the technology is necessary from a number of different perspectives. From your view of the world what are the drivers from a business, technology and career perspective? Have you heard insight or opinions related to employers view of SQL Server 2008? Do you have any suggestions when talking to management about moving to SQL Server 2008?
Top 10
Upgrading SQL Server databases and changing compatibility levels
When upgrading databases from an older version of SQL Server using either the backup and restore method or detach and attach method the compatibility level does not automatically change and therefore your databases still act as though they are running using an earlier version of SQL Server. From an overall standpoint this is not a major problem, but there are certain features that you will not be able to take advantage of unless your database compatibly level is changed. This tip will show you how to check the current compatibly level, how to change the compatibly level and also some of the differences between earlier versions and SQL Server 2005.
SQL Server 2008 R2 Upgrade Failure due to Security Group upgrade rule
Last month I was working on a SQL Server 2005 to SQL Server 2008 R2 upgrade. Unfortunately, we were not able to complete our upgrade because of a failing a upgrade rule named "Security Group SID (Security Identifier)". The SQL Server Upgrade Setup Wizard did not enable the 'Next' button in order to proceed with the upgrade until this failure was resolve. In this tip, I will describe the reason for this failure and how I fixed the issue in order to have a successful upgrade.
SQL Server 2008 Upgrade Plan for DBAs
At our organization we are in the planning stages of upgrading to SQL Server 2008. What are some of the key considerations as we plan to upgrade? How much time should be spent on planning? Who should do the planning? As a DBA, what are the technical aspects I should research? What is the best way to manage the project?
SQL Server Migration Assistant 2008 SSMA
One of my client’s requirements is to migrate and consolidate his company departments’ databases to SQL Server 2008. As I know the environment, they are using MySQL , MS-Access and SQL Server with different applications. Now the company has decided to have a single dedicated SQL Server 2008 database server to host all the applications. So there are a few things to do to upgrade and migrate from MySQL and MS-Access to SQL Server 2008. For the migration task, I found the SQL Server Migration Assistant 2008 (SSMA 2008) is very useful which reduces the effort and risk of migration. So in this tip, I will do an overview of SSMA 2008.
Version and Edition Upgrades with SQL Server 2008 R2
In most environments there may be a need to do an in place version or edition upgrade for an existing SQL Server installation. Microsoft makes this easy using the Edition Upgrade feature and in this tip we walk through the steps on how to do an upgrade to SQL Server 2008 R2 using this feature.
Why Upgrade to SQL Server 2008
With the recent release of SQL Server 2008, getting up to speed on the technology is necessary from a number of different perspectives. From your view of the world what are the drivers from a business, technology and career perspective? Have you heard insight or opinions related to employers view of SQL Server 2008? Do you have any suggestions when talking to management about moving to SQL Server 2008?
Upgrading to SQL Server 2008 Using Detach and Attach Operations
Like most other organization, we are planning the migration of a database from SQL Server 2005 to SQL Server 2008. As there is only one database which needs to be migrated as of now, I think it would be ideal to use the detach and attach operation to upgrade the user database from SQL Server 2005 to SQL Server 2008. In this tip we will go through a detailed explanation of how to use the detach and attach operation to upgrade a database.
Upgrading to SQL Server 2008 Using Backup and Restore Method
Like any organization, we are also planning the migration of a database from SQL Server 2005 to SQL Server 2008. As there is only one database which needs to be migrated as of now, I think it would be ideal to use the database backup and restore method to upgrade the user database from SQL Server 2005 to SQL Server 2008. In this tip we will go through a detailed explanation of how to use the database backup and restore method to upgrade a database.
Upgrading to SQL Server 2008 using Copy Database Wizard
As like in any organization we are also planning the migration of databases from SQL Server 2005 to SQL Server 2008. As there is only one database which needs to be migrated as of now, I think it would be ideal to use the Copy Database Wizard as it is best suited for such a scenario. Can you give us a detailed explanation of how to use the Copy Database Wizard to upgrade a database?
MySQL to SQL Server Conversion Tutorial
From time to time companies initiate projects to move from one database platform to another. Such migrations can involve switching between database engines such as SQL Server, MySQL, Oracle, Sybase, DB2, etc. In this tutorial we will explore the differences between MySQL and Microsoft SQL Server and the key components that you should be aware of when making that move.
Last 10
SQL Server 2008 R2 Upgrade Failure due to Security Group upgrade rule
Last month I was working on a SQL Server 2005 to SQL Server 2008 R2 upgrade. Unfortunately, we were not able to complete our upgrade because of a failing a upgrade rule named "Security Group SID (Security Identifier)". The SQL Server Upgrade Setup Wizard did not enable the 'Next' button in order to proceed with the upgrade until this failure was resolve. In this tip, I will describe the reason for this failure and how I fixed the issue in order to have a successful upgrade.
Version and Edition Upgrades with SQL Server 2008 R2
In most environments there may be a need to do an in place version or edition upgrade for an existing SQL Server installation. Microsoft makes this easy using the Edition Upgrade feature and in this tip we walk through the steps on how to do an upgrade to SQL Server 2008 R2 using this feature.
MySQL to SQL Server Conversion Tutorial
From time to time companies initiate projects to move from one database platform to another. Such migrations can involve switching between database engines such as SQL Server, MySQL, Oracle, Sybase, DB2, etc. In this tutorial we will explore the differences between MySQL and Microsoft SQL Server and the key components that you should be aware of when making that move.
SQL Server Migration Assistant 2008 SSMA
One of my client’s requirements is to migrate and consolidate his company departments’ databases to SQL Server 2008. As I know the environment, they are using MySQL , MS-Access and SQL Server with different applications. Now the company has decided to have a single dedicated SQL Server 2008 database server to host all the applications. So there are a few things to do to upgrade and migrate from MySQL and MS-Access to SQL Server 2008. For the migration task, I found the SQL Server Migration Assistant 2008 (SSMA 2008) is very useful which reduces the effort and risk of migration. So in this tip, I will do an overview of SSMA 2008.
Overview of Microsoft SQL Server 2008 Upgrade Advisor
Like most organizations, we are planning to upgrade our database server from SQL Server 2005 to SQL Server 2008. I would like to know is there an easy way to know in advance what kind of issues one may encounter when upgrading to a newer version of SQL Server? One way of doing this is to use the Microsoft SQL Server 2008 Upgrade Advisor to plan for upgrades from SQL Server 2000 or SQL Server 2005. In this tip we will take a look at how one can use the SQL Server 2008 Upgrade Advisor to identify potential issues before the upgrade.
Upgrading to SQL Server 2008 Using Backup and Restore Method
Like any organization, we are also planning the migration of a database from SQL Server 2005 to SQL Server 2008. As there is only one database which needs to be migrated as of now, I think it would be ideal to use the database backup and restore method to upgrade the user database from SQL Server 2005 to SQL Server 2008. In this tip we will go through a detailed explanation of how to use the database backup and restore method to upgrade a database.
Upgrading to SQL Server 2008 Using Detach and Attach Operations
Like most other organization, we are planning the migration of a database from SQL Server 2005 to SQL Server 2008. As there is only one database which needs to be migrated as of now, I think it would be ideal to use the detach and attach operation to upgrade the user database from SQL Server 2005 to SQL Server 2008. In this tip we will go through a detailed explanation of how to use the detach and attach operation to upgrade a database.
Transition from MS Access to SQL Server with the Migration Assistant
Our topic of this tip is going to be transitioning from being an Access Power User into a role of SQL Server Professional.
SQL Server 2008 Upgrade Plan for DBAs
At our organization we are in the planning stages of upgrading to SQL Server 2008. What are some of the key considerations as we plan to upgrade? How much time should be spent on planning? Who should do the planning? As a DBA, what are the technical aspects I should research? What is the best way to manage the project?
Upgrading to SQL Server 2008 using Copy Database Wizard
As like in any organization we are also planning the migration of databases from SQL Server 2005 to SQL Server 2008. As there is only one database which needs to be migrated as of now, I think it would be ideal to use the Copy Database Wizard as it is best suited for such a scenario. Can you give us a detailed explanation of how to use the Copy Database Wizard to upgrade a database?
