I am developing applications that use Microsoft sql server databases. I use SQL Server Management Studio to create these databases and add table, etc. I would like to be able to make a duplicate copy of one of these databases so that I could use one database for production and the other database for testing. Is there some way to do this? Also is there some way that I can copy a table in one database to another database?
View Complete Post