Programmatic Replication - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Programmatic Replication

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-02-20 : 09:20:18

Nithin writes "I have an existing database. i want to programmatically replicate this database. i.e i would like to create a new database and import all the tables and data from the old database into the new database created..please help me out.."

samrat
Yak Posting Veteran

94 Posts

Posted - 2002-02-21 : 08:26:59

Have you tried using DTS(Data Transformation Services). U can make a package in DTS and save it as Visual Basic module and run the DTS package when ever needed with parameters.

Let me know how you go

Samrat Valani

Edited by - samrat on 02/21/2002 08:27:33

kingnithin
Starting Member

4 Posts

Posted - 2002-02-22 : 06:57:19

Hi samrat,
i am the person who posted the question.well i would like to programattically create and copy tables in asp(active server pages)
Is it possible.Plz revert ASAP

quote:

Have you tried using DTS(Data Transformation Services). U can make a package in DTS and save it as Visual Basic module and run the DTS package when ever needed with parameters.

Let me know how you go

Samrat Valani

Edited by - samrat on 02/21/2002 08:27:33

kingnithin
Starting Member

4 Posts

Posted - 2002-02-22 : 06:57:36

Hi samrat,
i am the person who posted the question.well i would like to do the same in asp(active server pages)
Is it possible.Plz revert ASAP

quote:

Have you tried using DTS(Data Transformation Services). U can make a package in DTS and save it as Visual Basic module and run the DTS package when ever needed with parameters.

Let me know how you go

Samrat Valani

Edited by - samrat on 02/21/2002 08:27:33

khenry
Starting Member

16 Posts

Posted - 2002-02-22 : 07:24:43

yes if the DTS .dll refernces are in your global.asp

K e i t h H e n r y

kingnithin
Starting Member

4 Posts

Posted - 2002-02-24 : 23:30:34

Do you have any ideas which are the dll's that should be referenced.is it necessay the dll's be referenced from global.asa page only??do you have any sample code which you could share..my mail id is kingnithin@rediffmail.com

quote:

yes if the DTS .dll refernces are in your global.asp

K e i t h H e n r y

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources