October 28, 2009 at 11:59 am
I need to routinely copy and overwrite the data in all tables in one database with all the data in all tables in another one.
Is there an easy way of doing this?
Thank you!
October 28, 2009 at 12:05 pm
You may want to look at creating an SSIS package and then set it as a job in SQL Server.
October 28, 2009 at 12:10 pm
Well there are many ways to do it.. and all of them are easy depending on your experience with SQL Server.
Give more details in order to understand what you want to do.
You can use SSIS or Set Snapshot replication. If you don't to write SSIS packages and not use Replication, then you can write stored Procedures and use Linked Server and move the Data.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
October 28, 2009 at 12:17 pm
We have a web database and a local database.
There is no input in the web database. Only data is served on the website.
All input is done on the local database. I need to synchronize the website database with changes made in the website database.
We are doing this because our website and SQL server has been compromised before. We want to separate what is accessible internally and externally.
Thank you!
October 28, 2009 at 12:34 pm
You can make use of either SSIS or Replication (What type of Replications needs some understanding of the Table Sizes etc)
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
October 28, 2009 at 3:43 pm
rjv_rnjn + Bru
Thank you! The SSIS package did the trick.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply