Drop all table and repopulate
in [Programming SQL]
|
From: Rajesh on 1 Jul 2008 06:51 I want to drop all the tables and in a database and repopulate with the tables exist in the other server. What is the best method that i can do? While i am trying to drop the object i am getting error if it has dependencies how and i drop all the tables including all the dependicies.
From: vinu on 1 Jul 2008 07:00 Rajesh if you using sql 2000 then you can use DTS DTS has the facility to truncate the destination table and re-populate it vinu vinu <Rajesh Kallakuri> wrote in message news:20087165157rajinvizag(a)gmail.com... >I want to drop all the tables and in a database and repopulate with the >tables exist in the other server. > What is the best method that i can do? > > While i am trying to drop the object i am getting error if it has > dependencies how and i drop all the tables including all the dependicies. >
From: Uri Dimant on 1 Jul 2008 07:02 Hi I use RedGate tool and very happy with. You have to drop all constraints just before truncating and re-create after importing the data Take a look at Export/Import option in SQL Server, SSIS/DTS --transfer objects <Rajesh Kallakuri> wrote in message news:20087165157rajinvizag(a)gmail.com... >I want to drop all the tables and in a database and repopulate with the >tables exist in the other server. > What is the best method that i can do? > > While i am trying to drop the object i am getting error if it has > dependencies how and i drop all the tables including all the dependicies. >
From: Alex Kuznetsov on 1 Jul 2008 09:13 On Jul 1, 5:51 am, Rajesh Kallakuri wrote: > I want to drop all the tables and in a database and repopulate with the tables exist in the other server. > What is the best method that i can do? > > While i am trying to drop the object i am getting error if it has dependencies how and i drop all the tables including all the dependicies. you can drop the database, create a new one, create and populate your tables, and finally create constraints.
From: Bob on 1 Jul 2008 10:31
If you're dropping everything, why not just backup and restore? Surely this is the safest and simplest method. "Rajesh Kallakuri" wrote: > I want to drop all the tables and in a database and repopulate with the tables exist in the other server. > What is the best method that i can do? > > While i am trying to drop the object i am getting error if it has dependencies how and i drop all the tables including all the dependicies. > > |