Microsoft SQL Server

SQL Server Core Engineer Tips

Browse by Tags

Related Posts
  • Blog Post: Migración de SQL Server 2000 a SQL Server 2012

    No se puede migrar directamente a SQL Server 2000 a SQL Server 2012. La migración de SQL Server 2000 a 2012 requiere un paso intermedio. SQL Server 2012 soporta sólo los versiones siguiente: SQL 2005 SP4 o SQL 2008 SP2 o SQL 2008 R2 SP1. Si intenta restaurar una copia de seguridad...
  • Blog Post: Migration de SQL Server 2000 vers SQL Server 2012

    Vous ne pouvez pas migrer directement de SQL server 2000 vers SQL Server 2012. La migration de SQL server 2000 vers 2012 requière une étape intermèdiaire. SQL Server 2012 supporte une mise à jours uniquement depuis uniquement les versions suivantes : SQL 2005 SP4 ou SQL...
  • Blog Post: Migrating a cube in SQL Server Analysis Services 2005 to SQL Server Analysis Services 2008

    Migrating a cube in SQL Server Analysis Services 2005 to SQL Server Analysis Services 2008 You should consider migrating your cubes with one of 2 methods below: 1. Method Backup / Restore (recommended) 2. By copying the DATA directory on the second server while ensuring the SSAS service is stopped...
  • Blog Post: Migration SQL Server 2000 DTS to SSIS 2005/2008

    Migration DTS packages to SSIS 2005/2008 Setup SSIS with DTS 2000 On the migration of 2000 DTS to SSIS 2005/2008. There are many known issues in the migration of DTS 2000. It is recommended to execute the DTS inside SSIS 2005/2008 without migration. And if you need to edit a DTS in 2000 it will be better...
  • Blog Post: Migration SQL Server 2000 to SQL Server 2012

    You will be not able to migrate from SQL 2000 to 2012 directly. Migration from 2000 to 2012 requires an intermediate step. SQL Server 2012 supports upgrade from only the following versions: SQL 2005 SP4 or SQL 2008 SP2 or SQL 2008 R2 SP1. If you try to restore a backup database from SQL Server...
  • Blog Post: Migration SQL Server 2000 to SQL Server 2008

    The purpose of this post is to explain the minimum required for the migration of Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You can use the same principles to migrate a Microsoft SQL Server 2005 to Microsoft SQL Server 2008. 1. SQL server 2008 upgrade advisor 1.1. Before migrating Microsoft...