Import Data With Dependencies

#1

"Roy Goldhammer" wrote:

Quote:

I have an empty database that i need to fill it with another database
which
is similar. (backup of the current database)
In the database i have forign key constraints. So in order to enter data
to
one table with foreign key i need to add the data first to the table with
the primary key and afterword to the table with the foreign key
The simple DTS does not ckeck it. Is there a way to make shure that the
primary key is being filled before the foreign key?

"Copy SQL Server Objects" Task should work.
Otherwise you can first drop FK constraints, import data and then recreate
them.

--
Francesco Anti

#2

Hello there

I have an empty database that i need to fill it with another database which
is similar. (backup of the current database)
In the database i have forign key constraints. So in order to enter data to
one table with foreign key i need to add the data first to the table with
the primary key and afterword to the table with the foreign key

The simple DTS does not ckeck it. Is there a way to make shure that the
primary key is being filled before the foreign key?

--
øåòé âåìãäîø
ù.î. òúéã äðãñú úåëðä
roy (AT) atidsm (DOT) co.il
èì: 03-5611606
ôìà' 050-7709399

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Import Data With Dependencies

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Import Data With Dependencies - 08-05-2005 , 03:31 AM

Import Data With Dependencies - 08-05-2005 , 03:40 AM