Vborg
05-23-2002, 10:50 PM
Does anyone know how to go on about replicating a SQL server2000 database.
Assume that i have a DB called db1, and that i want to make a fresh new copy(withought any data) of db1 and name it db2.
I already know how to do the basic replication through the sql server DTS. However my replication is not 100%.
It doesnt replicate the table relationships, including the primary key and the foreign key.
It would also be great if i could do this through the VB interface.
Any help is much appreciated.
Assume that i have a DB called db1, and that i want to make a fresh new copy(withought any data) of db1 and name it db2.
I already know how to do the basic replication through the sql server DTS. However my replication is not 100%.
It doesnt replicate the table relationships, including the primary key and the foreign key.
It would also be great if i could do this through the VB interface.
Any help is much appreciated.