Any help is appreciated. Thanks.

patrickmcginnis59 10839- Thanks Patrick. I know I'm still at learning stage with SQL server and haven't done this transition of SQL server before. I appreciate your inputs.

ZZartin- I ran the 4 queries you suggested. I was able to truncate the destination database on the new server successfully. It shows the same number of rows as the...

ZZartin & patrickmcginnis59 10839,

Here is the result after running the script. I'm running the script on the new sql server 2014 under the destination database. Also the difference between the...

patrickmcginnis59 10839- Can you help me with the script? I appreciate your response. Thanks.

Need help guys. Thanks

ZZartin- I ran below script on my new SQL server using LinkedServers. The tables did not update. I mean I checked few tables. The number of rows in the original...

Thank you for your response. Below is the answer to your second question:

2) That was my other question, unless there's a reason you need to do updates your database is...

ZZartin- I appreciate your response. I've 25 tables in the database that has to be moved over to the new server. I already have the database restored on the new...

1)Are you going to be transitioning entire applications at one time or will applications be running in parallel on both platforms?

For now the applications will be running from the old...

sgmunson & J Livingston SQL - I appreciate your response. I modified the DDL and included the BATCH NUMBER per the business rule. Here is the business rule:

1) If the...

Yes, if the requested date was 2015-08-06 then the return date will be 2015-08-10. Thank you for your prompt response.

sgmunson,

Thank you for your response. The code you suggested works. I need to assign a Scheduled Ship Date to the closest Monday. For example- if the Requested Delivery Date is...

Marsha,

Yes, it is a DNS alias name for the server.

Thanks

Any help/suggestions is greatly appreciated. Thanks.