Nope, you lost me 🙂

I dont see any place where you mention the name of the table. (Customers)

OOPS I Posted in the Server 2005 area.

Sorry.

Anyway ..

Thanks for the reply. Will try that.

Okay how do I drop all the contraints ?

If I try to delete I get

The DELETE statement conflicted with the REFERENCE constraint "FK_ReportLog_Client"

=========================

Ooops 🙂 .

Msg 547, Level 16, State 0, Line 1

The INSERT statement conflicted with the FOREIGN KEY constraint "FK_LabLocationAnalysis_LabAnalysis". The conflict occurred in database "PM222", table "dbo.LabAnalysis".

The statement has been...

Great 😀 Thanks !

Thanks !

I need all the tables though , since I want the databases to be identical . One just smaller than the other.

-----------------------

Gianluca Sartori (6/9/2011)

---

This should be enough:

INSERT INTO DatabaseB..DestinationTable

SELECT...

It would be a one-shot deal.

Same instance.

Identical tables.

Gianluca Sartori (6/9/2011)

---

You have many options.

Is it a one-shot export or you have to it regularly?

Both databases on the same instance...

Okay , lets use this as an example.

MS SQL R2 Express 2008

Big live database has 10000 records. I want to use only a small portion of that for testing and...