Move table from one database to another database
-
Hello All, Need to move certain tables, not all tables from one database to another database, all the data and its properties. This is in SQL 2005? Any pointers? Thanks!
you have many choices. 1. import and export 2. using the following code, but it don't copy across any indexes etc.
select *
into database.owner.tablename
from tableAs barmey as a sack of badgers Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.
-
you have many choices. 1. import and export 2. using the following code, but it don't copy across any indexes etc.
select *
into database.owner.tablename
from tableAs barmey as a sack of badgers Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.
-
By performing the select, it does not copy over the indexes set up on the table, it just copies over the data. All features/properties of the table needs to copied over?
Create Script to Copy Database Schema and All The Objects – Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects[^] Have a read of that
As barmey as a sack of badgers Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.