I'm currently developing a administrative program. But I have one problem, wherefor I don't have the knowledge to solve.

This enterprise is working with an Exact database (SQL Server). The data may only be changed/manipulated by the program Exact itself. I'm not allowed to create new tables in the database manually and stuff. Otherwise our support contract expires.

Now for the program, I created a new database. Now I want to ask IF it's possible to DYNAMICALLY copy tables from 1 dbase to another, so if the fields from 1 table changes in the 1 it also changes in the other. So if there is added a new costumer in the table of the Exact dbase, the customer is also added in the new dbase table.

The 1st thing I had in mind was the copy of the whole table if this is possible. One step further if the previous is possible is that I only need 1 or 2 columns that need to be dynamically adjusted... So I get data from for exemple the column customername, and that the table that has the column costumername in the new database changes then.

Is this possible... It would be very handy, then I shouldn't have problems with 2 different connections for selecting & writing and stuff...

Tnx in advance!!!

I think if u can SELECT from Base DB u can use this:

• Creat same table in ub DB
• from ur DB use
  
  Code:

  INSERT INTO Table1
  SELECT * FROM DYNAMIC_SERVER.dbo.Table1

HTH.

Always:),
Hovik Melkomian.

in addition to melvik's suggestion. try creating a trigger on the table (concerned) on EXACT wherein it will update the corresponding table in your new database.
That is if your support contract allows it. :D

heh, best I have so much experience with it :p. Never ever used a trigger, but anywayz tnx for helping, I'll research it right away :)