How to transferr data

Question

How to transferr data

BuilderBits

SSCertifiable

Points: 6071
More actions
October 1, 2005 at 7:13 am

#169119

Hello all,
I have not yet got the hang of transferring data between machines.
i have been exporting data (entire table) to a text file and importing data into another sql2000 on a different machine using the same text file; however, after the transferr is complete i can never find the table in the database. Can someone plase tell me the best way to export and import data between machines..
Thanks,
erik

here is the text file.. **Please not this data is just test data.. its not meaningful
1,1,"Blue","22","45",2005-09-30 20:14:03.107000000
2,2,"Red","33","4555",2005-09-30 20:14:03.107000000
3,3,"Yellow","44","66",2005-09-30 20:14:03.107000000
4,4,"Blue","55","444",2005-09-30 20:14:03.107000000
5,5,"Black","66","88",2005-09-30 20:14:03.107000000
6,6,"Green","77","99",2005-09-30 20:14:03.107000000
7,7,"Purple","88","00",2005-09-30 20:14:03.107000000
8,8,"Rose","000","76",2005-09-30 20:14:03.107000000
9,9,"Orange","99","43",2005-09-30 20:14:03.107000000
10,10,"Snow","87","988",2005-09-30 20:14:03.107000000
Dam again!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Ian Yates SSCoach Points: 19738 More actions · Answer 1

What are you using to do the import / export? DTS (Data Transformation Services)? It is often called "Import & Export Data" in the start menu.

You can use DTS to pump data straight from one SQL Server to another, as well as specify the database on each server (even create new ones with default settings). If you use this tool, which works on a wizard basis, you should have better luck.

When you say you "can't find the table" - make sure you know which database you imported the data into and make sure you are looking in that database. Can you please specify what tools you are trying to use to look for the table - perhaps it is a table not owned by you (probably a difficult concept but most tables are owned by the "database owner" known as dbo - if you log on to the server using another user, it may be created with myUser.tablename rather than dbo.tableName). If you use enterprise manager or query analyser you should be able to find it.

BuilderBits SSCertifiable Points: 6071 More actions · Answer 2

I did end up finding the table.. sometimes i have to refresh the database a couple of times..

I did however have to name the columns because the column name did not make it with the text file...

thanks for the reply and help!

Dam again!