November 4, 2002 at 8:12 am
Hi,
I administer several SQL and App. servers and have a decision to make and was hopping to hear from people who have gone down that path. Here is the scenario:
Our developers have developed several web-based forms that accept data from users and upload them into a SQL2000. They also allow for large binary uploads into Windows file system, such as images, PDFs, etc.
We are weighting our options as per how to sync. that development environment with the production (combination of FTP and DTS, etc...). Maybe a script that can run on-demand. Or maybe there are tools out there so we don't have to re-invent the wheel.
Thanks
A.
November 4, 2002 at 9:00 am
What exactly do you want to sync up? Data only, or SP, and UDF's? All data, or only a subset of tables?
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
November 4, 2002 at 9:14 am
Data only, subset or full - either. Plus the binary files that are saved to a physical disk but have a pointer in the database.
November 4, 2002 at 9:22 am
If you are only moving specific tables then DTS will work nicely for you. Possible you could write an ActiveX DTS task to determine which binary files you need to move, and then issue the appropriate statements to copy the files from production to development.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
November 4, 2002 at 2:54 pm
If your looking for a tool to generate a script that will sync the SQLdata checkout SQLDatacompare
http://www.red-gate.com/sql_tools.htm
As for the file system - many options Robocopy?
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q160513&
Hope this helps
Tim
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply