Objective:
Use SQL Server Management Studio to generate a script which describes an object or stored procedure saved as a .sql text file on the local file system. Then use an instance of a SQL Server manager running on the host provider's servers to run the generated script(s) which will recreate the object(s) on the host provider's server.
Migrate Object Step 1:
- Load the local instance of the SQL database in SQL Server Management Studio.
- Select an object such as a Table object.
- Use the object's Context menu and select Script Table as > CREATE to > file.
- Save the file to the local file system, for example c:\scripted_TableToMigrate.sql
Migrate Object Step 2:
Login to the hosting service provider’s Control Panel.
Load the SQL Server manager the hosting service provides with their hosting plan.
Login to the database and open the Query Analyzer.
Copy the contents of the scripted_TableToMigrate.sql text file and paste into the Query Analyzer.
Execute the query.
The object should now be migrated (created) in the instance of the database being hosted by the service provider.
Migrate Data Step 1:
To migrate data use SQL Server Management Studio, connect to the Database Engine server type, expand Databases, right-click a database, point to Tasks, and then click Import Data or Export data.
Technorati Tags:
SQL Server
Subscribe