No es posible migrar 2000 a 2012 directamente, es necesario primero migrarlo a 2008, para esto, segui los siguientes pasos:<\/p>\n
<\/p>\n
Otras recomendaciones…<\/p>\n
<\/p>\n
–Primero ponemos la base de datos a modo mono-usuario<\/p>\n
ALTER DATABASE [BDMigrar] SET SINGLE_USER<\/p>\n
GO<\/p>\n
–Cambiamos el nivel de compatibilidad de 2005\/08\/08R2 a 2012<\/p>\n
EXEC sp_dbcmptlevel [BDMigrar], 110;<\/p>\n
GO<\/p>\n
–Por ultimo regresamos la base de datos a modo multi-usuario<\/p>\n
ALTER DATABASE [BDMigrar] SET MULTI_USER<\/p>\n
GO<\/p>\n
<\/p>\n
<\/p>\n
USE [BDMigrar]\n
GO<\/p>\n
DBCC CHECKDB;<\/p>\n
GO<\/p>\n
<\/p>\n
<\/p>\n
USE [BDMigrar]\n
GO<\/p>\n
DBCC UPDATEUSAGE ([BDMigrar])<\/p>\n
GO<\/p>\n
<\/p>\n
<\/p>\n
USE [BDMigrar]\n
GO<\/p>\n
ALTER INDEX [NombreIndice] ON [dbo].[TablaMigrada] REBUILD<\/p>\n
PARTITION = ALL WITH ( PAD_INDEX = OFF,<\/p>\n
STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON,<\/p>\n
ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF<\/p>\n
)<\/p>\n
GO<\/p>\n
<\/p>\n
<\/p>\n
use [BDMigrar]\n
GO<\/p>\n
UPDATE STATISTICS [dbo].[TablaMigrada]\n
WITH FULLSCAN<\/p>\n
GO<\/p>\n
<\/p>\n