SQL Server: Copy Table From dbase to other dbase
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!!!