copying table in a database

Hi good day to everybody,

Can we copy a table from a database and saved it into a diskette? Because i did not find or maybe i miss or doesn't know how to do it from EXPORT/IMPORT tools. The computer to where I attach the table is not connected on d'same network, and if I backup & then reinstall the whole database into that PC, all records in their will be overwritten by the new one which is not I wanted to be.Hi,

did you try to use dts? or copy you database to a webserver? or just copy your db to xml or a acces db ?

this could be intresting to you:
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21261328.html|||Thank you for the link, But i did not find the simpliest way to transfer a table from a database into a diskette and put it into another database in another computer not connected on the same network where i will take a table.

|||Hi,
IMO, there is no other simple way to copy a table. The last post was quite right. You'll have to convert it to a different format so that your destination computer could open it. A good format is access database (*.mdb) if your destination computer has access installed.

SQLServer stores its table,database,triggers,etc... information in a (*.mdf, *ldf) files usually found in C:\Program Files\Microsoft SQL Server\MSSQL\Data. But you can't copy it directly. You must stop the server first...

Contrast to that, if you want to copy the entire database, you could use the bacjup database and just restore it to the destination computer...
cheers,
Paul June A. Domag|||Thank you very much & have a nice day...|||

Paul Domag wrote:

You'll have to convert it to a different format so that your destination computer could open it. A good format is access database (*.mdb) if your destination computer has access installed.

and then how can I import the MDB table into the destination SQL server?|||Hi,
To import data from Access to SQL. You could use DTS (Data Transfer Service? not sure on the acronym). Its a wizard that migrates data from other sources to SQLServer...

cheers,
Paul June A. Domag

Copying a DTS Package and Jobs

Hi everybody,

Just want to ask how can I copy a DTS Package? Something like "Save As"...saving a DTS Package to another package name in the same server, or copying a DTS package to another server.

What I am doing right now, is I create the whole package again just to have another copy of it.

Same question with a Job.

Thank you so much. :)Why not try scripting it then just execute?|||for jobs u can right click on a job and use "generate sql script" to script it and execute it with QA.

for DTS it is a bit tricky. u can save-as an open DTS package as "structured storage file" (location drop-down). copy that disk file to another machine. and then right click on Data-Transformation-Services to open that saved package. need to save it again in SQL server of that machine.

Copying a DTS Package and Jobs

Hi everybody,

Just want to ask how can I copy a DTS Package? Something like "Save As"...saving a DTS Package to another package name in the same server, or copying a DTS package to another server.

What I am doing right now, is I create the whole package again just to have another copy of it.

Same question with a Job.

Thank you so much.Hey,

If you are using Enterprise manager, double click the package( or right click on the package, there will be a "Design package" option), it will open DTS Package designer, there you will find a menu under the main menu, click on Package and there will be a Save as... command there|||Hi Galexyus,

Thanks for taking the time to answer my query.
I found the "Save As" command already. What am I doing?
It's just in front of me, right before my very eyes. =)

Many thanks to you.
God Bless.