Jeff Moden (9/4/2015)

---

Grant Fritchey (9/2/2015)

---

I would focus on using PowerShell. You can make the call to the procedure, capture the output to file. It's the most direct mechanism available. You'll...

BL0B_EATER (9/7/2015)

---

Hi guys,

I was reading the following from BOL ( which is news to me and was wondering it was really true) ... as I find it a slightly odd?...

sqlfriends (9/7/2015)

---

Second thought, I can see records that entered 2 months ago, pretty recent, and we did not change any schema, or drop constraints , disable contraints, etc. so still...

Minnu (9/8/2015)

---

Thank you for suggestions.

Is there any third party tools or SQL Server tools to compare the DB's and generate automatic scripts to sync.

Is SQL Database manager will help on...

That's a huge topic. Yes, Visual Studio is your start point. Since you don't know what you're doing yet, an easy way to get going is using Lightswitch. I've used...

Create the scripts for the tables first. Then modify those scripts prior to running them. Search and replace should work fine as was already mentioned.

A second suggestion, use this as...

You already have it. OPENQUERY is the other option to query across the line. Otherwise, you can look to SSIS to migrate the data.

Jeff Moden (9/6/2015)

---

+1000... unless maybe...

SQL006 (9/5/2015)

---

I have 2 server A and Server B(remote 3rd party) both SQL server 2012. We need to query the data from remote Server B, we are planning to use...

Probably the foreign key was dropped at some point, the data was put in, and then the foreign key was reapplied using the WITH NOCHECK option. That will make it...

There's...

Based on the query alone, I don't see where to put either a SUM or a COUNT (and it could be either depending on your structure). How is an item...

Use Extended Events to capture the execution of the queries instead of writing to a log table.

You could try scripting them out, modify the start dates on the scripts, then drop and recreate the jobs all at once.

I would split those the same way. An alternate method is to use a table valued parameter.