Hi Phil, I do have the same data in multiple tables, that's because they are...

Ed Zann (7/30/2010)

---

If you only want to update specific rows in your sub-table, you would use a SQL Task in the Control Flow and write a standard SQL update query.

If...

Great thanks Phil and Elliot!!

I will run the test ASAP to see if there is anything I might just make the mistake, and will update the report of that. 😀

Only...

Elliott W (5/4/2010)

---

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...

Thanks very much Elliott.

As I understand your advices combining with my thought, please correct me if I am wrong in the following:

Assume I don't have DB2 at all now, and...

No Phil, they are far away from each other. 😀

First Thanks for your fast response and more questions could help us to clear all the confusions, which is good. 😀

You are right that REPLICATION is not using here at...

Elliott W (5/4/2010)

---

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....

I might clarify again, sorry for that.

1. DB1 is maintained by other group, they might update DB1 regularly, so we need to replicate their updates regularly to DB1.

2. DB2 is...

Sure.

My purpose is:

1. Replicate whole DB1 to DB2 with all the tables, views, sps, indexes, user role settings, BUT EXCEPT table1's 2nd, 3rd columns.

After that:

2. Update only DB2's table3...

Thanks Veeren. But is it related with credentials? and I already granted all controls to the user.

veeren4urs (3/5/2010)

---

Hi,

i am not saying the databases...

GO to the file in the SSMS>Connect Object Explorer>in that chosse server type as reporting services>Give u r credentilas>click on connect if get login...

U mean access the ReportServer DB and ReportServerTempDB from management studio?

Yes, I can.

rdls are deployed on the server, and all the operations are...

Hi Veenes, I tried your way, actually, I can access to url/ReportServer, but I can't access url/Reports.

Now I made such changes:

1. add http://url/reports to the RSWebApplication.config between <ReportServerUrl>...