SSRS Newbie (7/29/2015)
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 small enough you can just reload everything and not worry about it.
I need to automate the insert/update to the new server for now. Once we have everything in place we will be switching to the new server. This is just a precautionary step before switching entirely to the new server. Hope this helps.
Also, in regards to the script, do I need to run the script for each table schema? I mean I've 25 tables in the database. Should I run this script 25 times for each table?
Thanks, again.
If you have 25 tables in your db you can run that script once and your result set should be 25 lines, you could just copy and paste those into a query window or put them in a stored procedure or job step and run them.
Keep in mind that is clearly the tables in the target database.
If you just want to keep your 2014 up to date with your 2000 environment code you can run the code from the script I gave you however often you want. However if you're making changes in both environments and need to keep them synched(2000 up to 2014 and 2014 down to 2000) that would be a little more involved.