Overview<\/h3>\n\nThis document explains how to migrate TopTeam SQL Server Database<\/i> from one SQL Server <\/i>version to another.
\nThere are several options if you wish to move a database from an older version such as SQL Server 2005 <\/i>to the latest version of SQL Server<\/i>.
\nAn option which works without too much hassle is manually detaching and attaching the database\/log files.<\/p>\n
This document elaborates on this very approach.<\/p>\n<\/div>\n<\/div>\n
\nNOTE:<\/h3>\n\nTopTeam Database schema Export and Import utilities<\/strong>
\nTopTeam<\/i> has a native database schema export and import utilities to export and import TopTeam Database Schema<\/i> from one database to another.
\nHowever, these utilities are efficient to use only if you want to migrate data from one database type to another, e.g. from Firebird to SQL Server or from Oracle to SQL Server, etc.
\nTo migrate data from older SQL Server<\/i> version to the latest SQL Server version it is best to use the tools provided by Microsoft SQL Server<\/i>.<\/p>\nOther approaches to migrate data from older SQL Server version to the latest SQL Server version<\/strong>
\nRefer to the official website of SQL Server for more information on this topic.<\/p>\n<\/div>\n<\/div>\n\nWho should read this?<\/h3>\n\n\n- TopTeam Administrators<\/li>\n
- Database Administrators<\/li>\n
- IT Support<\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n
Prerequisites<\/h3>\n\n\n- You should have administrative access to the source and destination SQL Servers<\/i>.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n
Step 1. Detaching the database<\/h3>\n<\/div>\n\nStep 1.1. Identify TopTeam SQL Server Database Files<\/h4>\n![\"wpid32133-media_1282390745756.png\"](\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\")
<\/div>\n\nIdentify the TopTeam SQL Server Database files.<\/strong>
\nIn later steps, we will need to copy these files to the computer on which destination SQL Server is running.<\/p>\nIn the example above, TopTeam Database<\/i> name is TopTeam_Data<\/strong>.<\/i> You may have a different name as specified while installing TopTeam Database<\/i>.<\/p>\n<\/div>\n<\/div>\n\nStep 1.2. Detaching the database from Source SQL Server<\/h4>\n<\/div>\n\nSelect TopTeam Database<\/i> that you want to migrate, in the databases node of SQL Server Management Studio<\/i> as shown in the screenshot above.<\/p>\n
Right-click this database and select Detach<\/strong><\/i>. Ensure that the database is running (notice the green arrow in the SQL Server Instance name).<\/p>\n<\/div>\n<\/div>\n\nStep 1.3. Detach the database<\/h4>\n<\/div>\n\nClicking Detach…<\/strong> <\/i>will open the Detach Database<\/strong> <\/i>window as shown in the image above. Check Drop<\/strong> and click OK<\/strong>.<\/i>
\nThis removes the ‘TopTeam_Data’ node from the databases folder in SQL Server Management Studio<\/i> (you may need to attach it again).<\/p>\n<\/div>\n<\/div>\n\nStep 2. Copy the DATA\/LOG Files<\/h3>\n\nCopy the TopTeam_Data_Data.MDF<\/strong> and TopTeam_Data_Log.LDF%<\/strong> files to a location on the C: drive of the computer on which the destination SQL Server is installed.<\/p>\n<\/div>\n<\/div>\n\nStep 3. Attaching the database<\/h3>\n<\/div>\n\nStep 3.1. Select the Attach option in SQL Server Management Studio<\/h4>\n<\/div>\n\nIn SQL Server Management Studio<\/i>, right-click the Databases<\/i> node and click Attach…<\/strong><\/i> as shown in the image above.
\nClicking Attach<\/strong><\/i> will pop-up the Attach Databases<\/i> window.<\/p>\n<\/div>\n<\/div>\n\nStep 3.2. The Attach Databases window opens<\/h4>\n<\/div>\n\nThis step opens the Locate Database <\/i>Files folder\/file browser window. Locate the files you placed in Step 2. In this tutorial example, the files were placed in the location shown in the image.<\/p>\n<\/div>\n<\/div>\n\nStep 3.3. Select the detached TopTeam Database file<\/h4>\n<\/div>\n\nOpen the folder which contains the DATA \/LOG files and select the .MDF file. Now click the OK<\/i> button. This brings in the file information into the Attach Databases<\/strong><\/i> window. Although you just chose the .MDF file, the .LDF file is automatically brought in as well.
\nNow click the OK<\/i> button in the Attach Databases<\/i> window. Within a few seconds, the TopTeam_Data<\/strong><\/i> database appears in the Databases<\/i> folder of the destination SQL Server.<\/p>\n<\/div>\n<\/div>\n\nStep 3.4. The Attach Databases Window with file details<\/h4>\n<\/div>\n\nExpand the TopTeam_Data<\/strong><\/i> node and verify the Objects as shown in the next screenshot.<\/p>\n<\/div>\n<\/div>\n\nStep 3.5. Verify some of the transferred Objects in the destination SQL Server<\/h4>\n<\/div>\n\nTopTeam SQL Server Database<\/i> is now migrated to the destination SQL Server.
\nTry connecting TopTeam Application Server<\/i> or TopTeam Web Server<\/i> with TopTeam Database<\/i> in the latest SQL Server. Ensure that you change the Database Settings<\/strong><\/i> in TopTeam Server Management Console <\/i>so that TopTeam Server<\/i> connects to the right database.<\/p>\n<\/div>\n<\/div>\n
This document explains how to migrate TopTeam SQL Server Database<\/i> from one SQL Server <\/i>version to another.
\nThere are several options if you wish to move a database from an older version such as SQL Server 2005 <\/i>to the latest version of SQL Server<\/i>.
\nAn option which works without too much hassle is manually detaching and attaching the database\/log files.<\/p>\n
This document elaborates on this very approach.<\/p>\n<\/div>\n<\/div>\n
NOTE:<\/h3>\n\nTopTeam Database schema Export and Import utilities<\/strong>
\nTopTeam<\/i> has a native database schema export and import utilities to export and import TopTeam Database Schema<\/i> from one database to another.
\nHowever, these utilities are efficient to use only if you want to migrate data from one database type to another, e.g. from Firebird to SQL Server or from Oracle to SQL Server, etc.
\nTo migrate data from older SQL Server<\/i> version to the latest SQL Server version it is best to use the tools provided by Microsoft SQL Server<\/i>.<\/p>\nOther approaches to migrate data from older SQL Server version to the latest SQL Server version<\/strong>
\nRefer to the official website of SQL Server for more information on this topic.<\/p>\n<\/div>\n<\/div>\n\nWho should read this?<\/h3>\n\n\n- TopTeam Administrators<\/li>\n
- Database Administrators<\/li>\n
- IT Support<\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n
Prerequisites<\/h3>\n\n\n- You should have administrative access to the source and destination SQL Servers<\/i>.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n
Step 1. Detaching the database<\/h3>\n<\/div>\n\nStep 1.1. Identify TopTeam SQL Server Database Files<\/h4>\n<\/div>\n\nIdentify the TopTeam SQL Server Database files.<\/strong>
\nIn later steps, we will need to copy these files to the computer on which destination SQL Server is running.<\/p>\nIn the example above, TopTeam Database<\/i> name is TopTeam_Data<\/strong>.<\/i> You may have a different name as specified while installing TopTeam Database<\/i>.<\/p>\n<\/div>\n<\/div>\n\nStep 1.2. Detaching the database from Source SQL Server<\/h4>\n<\/div>\n\nSelect TopTeam Database<\/i> that you want to migrate, in the databases node of SQL Server Management Studio<\/i> as shown in the screenshot above.<\/p>\n
Right-click this database and select Detach<\/strong><\/i>. Ensure that the database is running (notice the green arrow in the SQL Server Instance name).<\/p>\n<\/div>\n<\/div>\n\nStep 1.3. Detach the database<\/h4>\n<\/div>\n\nClicking Detach…<\/strong> <\/i>will open the Detach Database<\/strong> <\/i>window as shown in the image above. Check Drop<\/strong> and click OK<\/strong>.<\/i>
\nThis removes the ‘TopTeam_Data’ node from the databases folder in SQL Server Management Studio<\/i> (you may need to attach it again).<\/p>\n<\/div>\n<\/div>\n\nStep 2. Copy the DATA\/LOG Files<\/h3>\n\nCopy the TopTeam_Data_Data.MDF<\/strong> and TopTeam_Data_Log.LDF%<\/strong> files to a location on the C: drive of the computer on which the destination SQL Server is installed.<\/p>\n<\/div>\n<\/div>\n\nStep 3. Attaching the database<\/h3>\n<\/div>\n\nStep 3.1. Select the Attach option in SQL Server Management Studio<\/h4>\n<\/div>\n\nIn SQL Server Management Studio<\/i>, right-click the Databases<\/i> node and click Attach…<\/strong><\/i> as shown in the image above.
\nClicking Attach<\/strong><\/i> will pop-up the Attach Databases<\/i> window.<\/p>\n<\/div>\n<\/div>\n\nStep 3.2. The Attach Databases window opens<\/h4>\n<\/div>\n\nThis step opens the Locate Database <\/i>Files folder\/file browser window. Locate the files you placed in Step 2. In this tutorial example, the files were placed in the location shown in the image.<\/p>\n<\/div>\n<\/div>\n\nStep 3.3. Select the detached TopTeam Database file<\/h4>\n<\/div>\n\nOpen the folder which contains the DATA \/LOG files and select the .MDF file. Now click the OK<\/i> button. This brings in the file information into the Attach Databases<\/strong><\/i> window. Although you just chose the .MDF file, the .LDF file is automatically brought in as well.
\nNow click the OK<\/i> button in the Attach Databases<\/i> window. Within a few seconds, the TopTeam_Data<\/strong><\/i> database appears in the Databases<\/i> folder of the destination SQL Server.<\/p>\n<\/div>\n<\/div>\n\nStep 3.4. The Attach Databases Window with file details<\/h4>\n<\/div>\n\nExpand the TopTeam_Data<\/strong><\/i> node and verify the Objects as shown in the next screenshot.<\/p>\n<\/div>\n<\/div>\n\nStep 3.5. Verify some of the transferred Objects in the destination SQL Server<\/h4>\n<\/div>\n\nTopTeam SQL Server Database<\/i> is now migrated to the destination SQL Server.
\nTry connecting TopTeam Application Server<\/i> or TopTeam Web Server<\/i> with TopTeam Database<\/i> in the latest SQL Server. Ensure that you change the Database Settings<\/strong><\/i> in TopTeam Server Management Console <\/i>so that TopTeam Server<\/i> connects to the right database.<\/p>\n<\/div>\n<\/div>\n
TopTeam Database schema Export and Import utilities<\/strong> Other approaches to migrate data from older SQL Server version to the latest SQL Server version<\/strong> Identify the TopTeam SQL Server Database files.<\/strong> In the example above, TopTeam Database<\/i> name is TopTeam_Data<\/strong>.<\/i> You may have a different name as specified while installing TopTeam Database<\/i>.<\/p>\n<\/div>\n<\/div>\n Select TopTeam Database<\/i> that you want to migrate, in the databases node of SQL Server Management Studio<\/i> as shown in the screenshot above.<\/p>\n Right-click this database and select Detach<\/strong><\/i>. Ensure that the database is running (notice the green arrow in the SQL Server Instance name).<\/p>\n<\/div>\n<\/div>\n Clicking Detach…<\/strong> <\/i>will open the Detach Database<\/strong> <\/i>window as shown in the image above. Check Drop<\/strong> and click OK<\/strong>.<\/i> Copy the TopTeam_Data_Data.MDF<\/strong> and TopTeam_Data_Log.LDF%<\/strong> files to a location on the C: drive of the computer on which the destination SQL Server is installed.<\/p>\n<\/div>\n<\/div>\n In SQL Server Management Studio<\/i>, right-click the Databases<\/i> node and click Attach…<\/strong><\/i> as shown in the image above. This step opens the Locate Database <\/i>Files folder\/file browser window. Locate the files you placed in Step 2. In this tutorial example, the files were placed in the location shown in the image.<\/p>\n<\/div>\n<\/div>\n Open the folder which contains the DATA \/LOG files and select the .MDF file. Now click the OK<\/i> button. This brings in the file information into the Attach Databases<\/strong><\/i> window. Although you just chose the .MDF file, the .LDF file is automatically brought in as well. Expand the TopTeam_Data<\/strong><\/i> node and verify the Objects as shown in the next screenshot.<\/p>\n<\/div>\n<\/div>\n TopTeam SQL Server Database<\/i> is now migrated to the destination SQL Server.
\nTopTeam<\/i> has a native database schema export and import utilities to export and import TopTeam Database Schema<\/i> from one database to another.
\nHowever, these utilities are efficient to use only if you want to migrate data from one database type to another, e.g. from Firebird to SQL Server or from Oracle to SQL Server, etc.
\nTo migrate data from older SQL Server<\/i> version to the latest SQL Server version it is best to use the tools provided by Microsoft SQL Server<\/i>.<\/p>\n
\nRefer to the official website of SQL Server for more information on this topic.<\/p>\n<\/div>\n<\/div>\nWho should read this?<\/h3>\n
\n
Prerequisites<\/h3>\n
\n
Step 1. Detaching the database<\/h3>\n<\/div>\n
Step 1.1. Identify TopTeam SQL Server Database Files<\/h4>\n
<\/div>\n
\nIn later steps, we will need to copy these files to the computer on which destination SQL Server is running.<\/p>\nStep 1.2. Detaching the database from Source SQL Server<\/h4>\n
<\/div>\n
Step 1.3. Detach the database<\/h4>\n
<\/div>\n
\nThis removes the ‘TopTeam_Data’ node from the databases folder in SQL Server Management Studio<\/i> (you may need to attach it again).<\/p>\n<\/div>\n<\/div>\nStep 2. Copy the DATA\/LOG Files<\/h3>\n
Step 3. Attaching the database<\/h3>\n<\/div>\n
Step 3.1. Select the Attach option in SQL Server Management Studio<\/h4>\n
<\/div>\n
\nClicking Attach<\/strong><\/i> will pop-up the Attach Databases<\/i> window.<\/p>\n<\/div>\n<\/div>\nStep 3.2. The Attach Databases window opens<\/h4>\n
<\/div>\n
Step 3.3. Select the detached TopTeam Database file<\/h4>\n
<\/div>\n
\nNow click the OK<\/i> button in the Attach Databases<\/i> window. Within a few seconds, the TopTeam_Data<\/strong><\/i> database appears in the Databases<\/i> folder of the destination SQL Server.<\/p>\n<\/div>\n<\/div>\nStep 3.4. The Attach Databases Window with file details<\/h4>\n
<\/div>\n
Step 3.5. Verify some of the transferred Objects in the destination SQL Server<\/h4>\n
<\/div>\n
\nTry connecting TopTeam Application Server<\/i> or TopTeam Web Server<\/i> with TopTeam Database<\/i> in the latest SQL Server. Ensure that you change the Database Settings<\/strong><\/i> in TopTeam Server Management Console <\/i>so that TopTeam Server<\/i> connects to the right database.<\/p>\n<\/div>\n<\/div>\n