Import + Export Problems

[WJProctor]

Hi,

Ive been importing some tables from one Server to another, but the problem is that when i do the tables do not get carried over exactly the same. For example it does not copy across that certain fields are key fields, and also it changes fields that were numeric to decimal ones. Why is this happening and is there anyway to copy the tables exactly.

Regards

James Proctor

http://www.ebmis.co.uk

 

[nigelrivett]

How are you copying the tables?
Try using dmo
see

http://www.nigelrivett.net/SQL-DMOTransfer.html

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[WJProctor]

Well im just using the import data feature on MSSQL Enterprize manager. Shouldnt i be using this?

James Proctor

http://www.ebmis.co.uk