November 28, 2007 at 6:41 am
Hi,
I'm new to SQL Server, we currently develop systems using Paradox. We are outsourcing the creation of a web based lead management system to a 3rd party who will use .NET and SQL Server 2000. Our challenge is to feed leads that are generated on our Paradox system into their SQL Server 2000 database. I am just trying to get an idea of the best way to achieve this. We have a SQL Server 2000 database on-site which is part of SBS 2003 so we could write the records straight from Paradox in SQL Server 2000 here and then use DTS to send data across. What we have to ensure is that when a lead is generated it gets to the SQL Server 2000 database of our 3rd party ASAP ie we cannot bulk upload data nightly.
Any suggestions appreciated
Jon
November 28, 2007 at 7:21 am
When you say you can't do bulk insert nightly, is this because you need to keep their test box us up to date as possible?
Replication?
Log shipping?
Two good methods which are available to SQL2000.
Alternatively, maybe you could export data via a scheduled job, out into csv, xml and place it on your FTP site. They could have a similar job to pull the data and import it.
November 28, 2007 at 7:32 am
- Do the two SQL server "see each other"? ARe you using linked servers or do you need something more asynchronous?
- Nothing forces you to do this once a day. What's fast enough? every 15 minutes? every 5 minutes?
Extracting data ever few minutes to a new file really isn't all that tough. Just build the process so that you don't overwrite the older versions of the file extracts (in case your connection to the remote server goes wonky one day). Similarly - build the import process on the remote server to be able to pull data from any number of files.
Most straightforward way to do this for me was to use a parameterized DTS package, where I could "feed" it the name of the file I want to build or import. I would then control it from the OS scheduler (usually a batch file or a .NET console app depending on what was required, which would submit each file in a given directory for processing).
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply