Q
Problem solve Get help with specific problems with your technologies, process and projects.

How to upload tables and import data to local host

I have created database tables for a sit. I wish to know how to upload the tables and import the data to my local host.

You can simply connect to the database using Enterprise Manager, or your favorite management tool like DBArtisan, and generate the DDL scripts. You then run those scripts to create the tables and other objects. You can move the data via 1 of 2 mechanisms. If you have connectivity to both locations from a single point, you can use DTS to simply move the data. If you don't, then you BCP the data out to text files, transfer the text files, and then BCP them in on the other side.

 

For More Information

Dig Deeper on Microsoft SQL Server Installation

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close