Phil Parkin (5/4/2010)

---

Do your backups and restores using Execute SQL tasks.

After backing up on server 1 you'll need to transfer the file to server 2 before it is restored. I...

Step 1. I'm not talking about using the transfer objects at all, Step 1 is a backup and restore, which can be be in an SSIS package.

Step 4. when...

Good question Phil.

CEWII

Ok, 300M is nothing, even 5-10GB is really not all that big in my opinion.

Your concern over sensitive data is good. I see a couple options, both of which...

If I understand your requirement this will probably generate a script that can be run to create the relationships you are wanting:

SELECT '--Cmd' = 'ALTER TABLE dbo.'

...

First I want to stop using the term replication, the reason is that it implies some things that aren't in play. In SQL Server there are several types of...

Ok, then I think I am starting to see the problem..

Also I'm not recommending a For loop.

It sounds like the recordset being passed into the F-E-L contains too many records....

I'm not 100% sure but I think SSIS will only use assemblies that are installed in the GAC. I'm willing to bet that the DLL's you are looking for...

Lowell,

Perhaps I read that a little differently than you did, I thought he was talking about foreign keys, if he was talking about views then my advice doesn't apply..

CEWII

I think you are getting the cart before the horse. Install SQL. Also, what user is DTC using to login, I believe the right answer should be NT...

Are the tables all similar or do they have the same key structure? If so then a script could be generated to do it. But if we are...

For the initial copy I would probably just do a backup/restore. For the others I would probably build SSIS packages to copy the data back and forth. The...

I'm confused.

How many records are in the ADO Recordset that the Foreach Loop containter is iterating through? If it is 18 then the container will execute its...

Is the DTC in the same resource group as the SQL Server and its log is on a disk in that resource group?

CEWII

Duplicate post, please reply to http://www.sqlservercentral.com/Forums/Topic913573-391-1.aspx

CEWII