Sql Server2000 Database Replication

05-23-2002, 11: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.

05-24-2002, 12:21 AM
This isn't exactly what you want, but in SQL Server 7, I like to use
the Enterprise Manager to generate scripts. I can include all
tables, indexes, stored procs, etc. It is an easy matter to modify
the script to create new databases and make it into a stored proc.
that can be executed from VB or anywhere.

05-24-2002, 12:29 AM
Sounds great.
Will definately give it a try.

Thanx dude :)

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum