I have a database with a table. I want copy it along with the data to another database.
How can I do this in SQL server 2005 express?
Asked
Active
Viewed 1,214 times
1
-
Have you seen this? http://aspalliance.com/888 – chickeninabiscuit May 31 '10 at 10:49
-
1Similar post: http://stackoverflow.com/questions/187770/copy-tables-from-one-database-to-another-in-sql-server – chickeninabiscuit May 31 '10 at 10:50
-
> Similar post: stackoverflow.com/questions/187770/… Note that the accepted answer will only copy the data; look at the answer further down which also advises how to script the table creation as well. – kevinw May 31 '10 at 10:58