Tuesday, May 20, 2008

Copying records from database into another -- SQL

I had this requirement today where I had to copy from a table in one database into a similar table in another database.

the code I have used in

insert into database1.dbo.table1 select * from database2.dbo.table1 where xxxxx

where xxxx is the criteria that you need to add.

Precautions you have to tak before you do this.

Backup the database into which you are copying the record so that you can restore if something goes wrong.
Copy contents when there are no other transactions being entered into the database1

No comments:

My first experience with SQL Server Database Partitioning

At my work I have inherited a database where the partitioning was not done correctly.  This database holds millions and millions of records...