Is there any way to import tables from a sql database on an nt workstation to a sql database on a server? If so how do you do it.

How It Works

Get an answer in three easy steps. Here's how it works...

1. Ask Your Question

Enter your programming question at the top of this page and click Get An Answer.

2. Pick Your Priority

Tell us how quickly you want your programming question answered.

3. Get An Answer

Connect with your programmer via online chat or telephone call.

Get An Answer

Answer

Customer

Is there any way to import tables from a sql database on an nt workstation to a sql database on a server? If so how do you do it.

Posted 1/2/2001

Matthew Pomar

Customer Support

I'm assuming you are running MSDE on your workstation. In that case, you can use SQL Enterprise Manager's "Import and Export Data" tool - better know as Data Transfomation Services or DTS. Once you launch the program, the wizard should step you through the steps to transfer the database to the server. Hope this helps. Regards, Matthew Pomar

Posted 1/2/2001

Customer

Thank-you for the quick response. I do not know if the workstation is running MSDE. I tried using the DTS on the sql server and it did not see the workstation to import any data. I can copy the data files from the workstation into a directory on the server, but was still not able to import them. What should I try next?

Posted 1/2/2001

Matthew Pomar

Customer Support

I would try to figure out why you cannot see the workstation. Are you running on the same physical network? What protocals are you running? What's your default library (Named Pipes, TCP/IP)? An alternative to this method is to detach the database and attach in on the server. Use SQL Server Books Online for information on these methods. Regards, Matthew Pomar

Posted 1/3/2001

cckane1973

Programmer

If the SQL SERVER does not see the workstation, best thing to do would be to put the name of the workstation in manually. I have this same problem, and entering the machine name in by hand is how i have resolved the issue, at least on SQL2000

Posted 3/12/2001

Get An Answer

Testimonials

Featured Programmer

Byron Narciso
Programmer

Byron has over 15 years of Technical Support Experience with expertise on Windows, Apple devices , Android, Virus Removal, Cloud Computing, Email Configuration, Smartphones, Facebook, Instagram, Kindle, Twitter,Dropbox, Linkedin, Printer configurations and Networking. He has worked for some of the top computer manufacturers in the world and has served as a Subject Matter Expert for Level 1 and 2 technicians providing assistance in resolving advance technical issues. Byron holds a degree in Electronics and Communications Engineering with a DSCE and CCNA certification.

About ExpertHelp

ExpertHelp is changing the way you connect with service professionals.

Whether you have a quick question while preparing your taxes, troubleshooting a computer problem, or need to hire an attorney, ExpertHelp is the most convenient and affordable way to connect with the right service professional to get the job done.

ExpertHelp has been in business since 2011, is an A+ Rated Better Business Bureau accredited member, and offers a 100% satisfaction guarantee on every question you ask!

Get An Answer

Is there any way to import tables from a sql database on an nt workstation to a sql database on a server? If so how do you do it.

How It Works

Get an answer in three easy steps. Here's how it works...

1. Ask Your Question

2. Pick Your Priority

3. Get An Answer

Answer

Testimonials

Featured Programmer

About ExpertHelp

ExpertHelp is changing the way you connect with service professionals.

More Programming Questions...

Ask Your Programming Question & Get An Answer Now!