How to import data from one sql server database to another using VB.NET

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

I have been developing application using VB.NET and SQL Server 2005. There is one software is already been developed and in running mode, now I have to develop facility that user can add one record on that software and same record will add into my database table also.

For that I have to write some code for when I will open particular screen / page in my application it will check the database table on said software/application and found if any new entry/record than it will appear in my application screen also, in other words it will retrieve data from said software's Database and save into my application database.

In short I have to import record for database table from one database to another database using VB.NET code.

Please advice.

Anyone can please help me on this??

Posted 21-Nov-12 1:36am

Jitendra sondarva

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Rajesh Pandya · Accepted Answer · 2012-11-22T02:36:00

Hi,

You should use SQL Trigger functionality for this, by using Trigger you should get this easily. For this you have to write one Insert Trigger on your
First DB (Destination DB - Existing software DB). When record insert on particular table in (Destination DB - Existing software DB)'s table it will automatically
insert into you Source DB particular table using Trigger.

Review below sample SQL code for

CREATE TRIGGER another_db_insert ON test_table FOR INSERT
AS
BEGIN
BEGIN TRANSACTION test_insert

-- Destination Database Test_Destination_DB
INSERT INTO Test_Destination_DB.dbo.destination_table(Id, Name)
SELECT Id, Name FROM inserted AS Source_table

IF (@@ERROR != 0)
BEGIN
ROLLBACK TRANSACTION test_insert
RETURN 0
END
ELSE
BEGIN
COMMIT TRANSACTION test_insert
RETURN 1
END
END

Hope this will works for you! Good luck

NOTE: This will works if both databases are on same SQL server.