MS SQL Import Tool?

Status
This thread has been Locked and is not open to further replies. The original thread starter may use the Report button to request it be reopened but anyone else with a similar issue should start a New Thread. Watch our Welcome Guide to learn how to use this site.

abrown72

Thread Starter
Joined
Jun 17, 2005
Messages
24
Hey everyone I am starting to get a little frustriated. I am not a query expert at all. I have 2 identical MS SQL databases in 2 location "Live" and "Test". Live is full of data and I want to import that data into "Test" for testing DB driven apps. Here is my problem.

Through my web host I can right click on each table export as either a CSV or an XML. Ok so I have both, now I want to "Import" into the test DB tables. Is there no sigle peice of DB Management software out there that lets you Import data into a DB as easy as it is to export, as in right click on table and selet "Import Data"

If anyone knows of any I would be in you debt...

THanks!
 
Status
This thread has been Locked and is not open to further replies. The original thread starter may use the Report button to request it be reopened but anyone else with a similar issue should start a New Thread. Watch our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top