May 28th, 2004, 01:49 AM
|
|
Registered User
|
|
Join Date: May 2004
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Stuck Up while Working With SQL Server and SQLDMO
Hi Guys!!
Need Some Help,I am working on an Application using VB 6.0. where in I need to alter tables of one database comparing with the tables with another one. In other words.
I have one database db1 and another database db2
In db1 i have table table1 and in db2 I have the same table table2. Now in case if any changes are done to table1 in db1. I want to make those changes in the table table1 of db2. I want to alter the table accordingly. I am using SQLDMO for this but could not really achieve this.
Another problem is.
I want to insert records from few tables from db1 to the similar tables in db2. I have tried using BCP but it doesnot work . Export works properly but Import doesnt. Then I tried writing Stored Procedure where i pass the insert into command as a parameter and execute the query. But in case if the Identity property for any field is set to true. It gives me error. If I try to use "Set IDENTITY_INSERT "TABLE NAME" ON" it doesnot allow me to pass the table name as a parameter.
Please Help
Its Urgent
Email: rahulk@easypack.bz
Regards
Rahul.
Last edited by Rahul Kate : May 28th, 2004 at 02:03 AM.
Reason: Change in Subject
|
ASP Free Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
