Tag Info

New answers tagged

0

First I agree you should not migrate from 2000 to 2012 directly. I think that process has been covered well. I wanted to suggest you find out for sure if anyone is using the databases and what they are using them for. It may be that they are not being used. It happens and if that is the case then you have no worries. It might be that adding 2 or 3 tables and ...


0

You say you "have come across three old databases sitting on SQL Server 2000" which leads me to believe you only need the data. I would guess that if they were being run for a purpose, you would know. If this is the case, ignore all questions of users, security, etc. Import/Export wizard all the tables Script the stored procedures and views Check for ...


0

You can not migrate directly from SQL Server 2000 to SQL Server 2012, and if you try to do it you will get the following error number 3169, that is related to compatibility issues. The migration to SQL Server 2012 can be done from one of the following versions (minimum versions) SQL Server 2005 SP4 or SQL Server 2008 SP2 or SQL Server 2008 R2 SP1. So ...


6

Stating there is no workaround seems a little premature. You say your database only contains a few tables and views. Why not export the tables and views schema as SQL create statements and run them on your target database? You could then also export the actual data into something like CSV format and import them into the target database, or perhaps even ...


17

No, there is no workaround to upgrading a database directly from 2000 to 2012. Since you don't have a ton of data, you can do all kinds of things to move the data (but not the database as a whole), including: Import/Export wizard SSIS BCP Manual queries using a linked server from 2012 or an application However these will not necessarily bring over other ...


2

No, you cannot migrate it directly from 2000 to 2012. What you can do is install a temporary instance of 2005 OR 2008 oR 2008R2, restore the 2000 database here. Once done you can now upgrade from installed instance by taking the backup of database from that instance and restoring onto sql server 2012. You will have to make the migration in two steps: ...



Top 50 recent answers are included