This tip is on databases. Here you go — free on us — compliments of http://www.sozohosting.com/ and also compliments of http://www.biznesstechnologies.com/ :

 

How do I load an MS SQL 2005 Database Using MS SQL 2005 Server Management Studio?

 

MS SQL 2005 Server Management Studio is different than doing Imports and Exports with Enterprise Manager (MS SQL 2000). You need to learn how to script the database that you are copying from and then run that DB script on the empty database that you want to import to. Scripting databases is not an easy topic you can learn by reading 1 paragraph here. You need a DB administrator to script a database or buy some good books on the topic.

Just doing a simple Import or Export with MS SQL 2005 Server Management Studio can help you load data initially in your tables but you can lose the identity field increment options on a table if you don’t know what you are doing. However if you have a small database and don’t use identity field increment options or indexes you can do the following steps.

Open MS SQL 2005 Server Management Studio and click on the database you want as the source to copy from. Right click on that database and choose the Tasks menu then the Import Data menu option under that Tasks menu. This will open up the SOURCE dialog box. Leave the Data Source as “SQL NATIVE Client” and change the server name to the source server or source IP. Enter your SQL Server authentication and choose the correct database. Click the next button to open up the DESTINATION dialog box. Leave the Data Source as “SQL NATIVE Client” and change the server name to the destination server or source IP. Enter your SQL Server authentication and choose the correct database. DOUBLE CHECK YOU HAVE THE RIGHT DATABASE. Click the next button to open up the Table/Query Dialog box. Choose either selection however if you are not running a DB script then choose the top option and click Next. Choose the tables you want to import or select the ALL button at the bottom. Click Next to go to the Execution Dialog box. Here you can click Finish to execute the IMPORT or you can save it if you are going to do this import often. You will be notified when the IMPORT is complete.

Categories: Uncategorized ,Web Hosting ,Web Hosting and Database Tips


Leave a Reply

You must be logged in to post a comment.