Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old July 7th, 2004, 03:10 AM
Registered User
Join Date: Jul 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to orez
Default 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!!!

Old July 7th, 2004, 03:20 AM
Friend of Wrox
Join Date: Jun 2003
Posts: 996
Thanks: 2
Thanked 11 Times in 11 Posts
Send a message via Yahoo to melvik

I think if u can SELECT from Base DB u can use this:
  • Creat same table in ub DB
  • from ur DB use
    INSERT INTO Table1


Hovik Melkomian.
Old July 7th, 2004, 03:49 AM
Authorized User
Join Date: Jul 2004
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts

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

Old July 7th, 2004, 03:51 AM
Registered User
Join Date: Jul 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to orez

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 :)

Similar Threads
Thread Thread Starter Forum Replies Last Post
Chap 12 connection to a dbase jardbf BOOK: Beginning ASP 3.0 1 May 25th, 2006 11:01 AM
connection to dbase jardbf Classic ASP Basics 0 May 23rd, 2006 04:10 AM
Multiple Connections to dBase derekinit Classic ASP Databases 0 June 3rd, 2005 09:35 PM
Script To Write to Dbase HELP!!! reidcor VBScript 3 January 20th, 2005 05:12 AM
Repairing an ACCESS Dbase... dgarcia1128 Access 4 March 1st, 2004 03:29 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.