Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Importing data from t database

Author  Topic 

kamii47
Constraint Violating Yak Guru

353 Posts

Posted - 2006-07-26 : 05:31:16
I have a readonly access to a database.
I have generated scripts of all the objects and make a database locally.
Then I imported all data with object in another DB locally.
First contains all the relationships[but not data] while second db contains all the data.
Could I import data from the second db to the relational one.
IF I use import Data wizard then Some table's data not copied
what Can I do

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2006-07-26 : 06:25:37
Are you getting any error emssages? What are thay saying...?

--
Lumbago
"Real programmers don't document, if it was hard to write it should be hard to understand"
Go to Top of Page
   

- Advertisement -