Requires Free Membership to View
You are in luck! Since all of the SQL Server objects (tables, stored procedures, triggers, functions, etc.) are stored as T-SQL code in the system tables, it is possible to script out the objects in the SQL Server 7.0 objects and apply to the SQL Server 2000 environment. Scripting out the objects can be achieved by leveraging the SQL Server scripting application in Enterprise Manager. With this application it is possible to save the contents of the application to a local file or to the clip board, which can be pasted into Query Analyzer for execution. Below outlines the high level steps to access the script generation application in SQL Server 2000 Enterprise Manager.
1. Right click on the database name, select the 'All Tasks' option and then the 'Generate SQL Script...' option to start the application residing in Enterprise Manager.
Figure 1 – Enterprise Manager – Generate SQL Script…
2. On the first tab select the objects of interest.
Figure 2 – Generate SQL Scripts – General Tab
3. Select the appropriate formatting options for the output.
Figure 3 – Generate SQL Scripts – Formatting Tab
4. Select the security, table and file options, then press 'OK' for the option to save the contents to disk or click back on the General Tab to 'Preview' the code and then save it to the clip board.
Figure 4 – Generate SQL Scripts – Options Tab
As you are in the process of moving these objects want to think about a formalized Upgrade and Change Management process. For more information check out:
Good luck with your upgrades and get ready to start upgrades to Yukon, the next version of SQL Server towards the end of 2004 or early 2005!This was first published in March 2004
Join the conversationComment
Share
Comments
Results
Contribute to the conversation