September 25, 2002 at 2:10 am
I am having a DataBase residing on a Webserver. I want to pull only the updated records in the SQL Server database on my local computer. I dont have a fixed Public IP on my local computer. I will be transfering the data from the webserver to my local computer using a Dial-Up internet connection.. Please let me know the process..
JOHN MENDONCA
September 25, 2002 at 4:23 am
Not sure Im clear - you'll host SQL on your local machine, you want to move changed records TO the web server, or from the web server to the local machine? Are your users changing records on the server? Would it be just updates or inserts (and maybe deletes) as well? What database are you using on the web server?
Andy
September 25, 2002 at 5:01 am
With a nonstatic IP you may have better results going either way if you create a change notation table and place a trigger on the main table.
For exxample.
I have an employee table with an EmpID, FirstName, LastName, DOB, Position, and Phone
Now on this table I place a FOR INSERT, UPDATE, DELETE trigger on it. Because EmpID is unique I have a control item when when any of the FOR items occurr I fire the trigger to look at the change and copy the EmpID to the Control Notation table with say an Event Marker (I, U, D).
When you connect you look at the control table you pull down the control table and remove the data, then you perform the related item on the related records based on the items in the control table.
The only issue may be if you have a high number of transactions to make sure you do not cause yourself issues. Which in that case I do the following, create two control tables, and a stored procedure to insert the records to one or the other. The trigger calls the sp. When you are ready to work with the control table you alter the sp to push data to the other control table and then you can work with the one. Next time you then reverse. This will keep transactions from getting stepped on.
Hope this offers enough help.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
September 25, 2002 at 5:26 am
I want to transfer only the updated records of a database from the webserver to the local sql server database.. On the webserver database records will be inserted, updated and also deleted.. But it will be only a one way transfer of updated records (webserver-updated records to local).. Can I use SQL Server Replication Process ? moreover I am using SQL Server 2000 and I want to schedule this process...
JOHN
September 25, 2002 at 7:51 am
Using SQL2K on the web server too?
Andy
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply