Hello!
Good day!
I have a problem regarding to my MSSQL db. I have a database name named db1 with huge structure of tables and has a series of data also.
I would like to copy the db1 to the newly created db. with the db1 tables structure and data. In other words, i just want to duplicate it. May i know whats the right code for this? By, the i'm using microsoft SQL server 2005 and mssql server studio. Is there any short cut to duplicate a db to another db with the same server?
I'm just a returnee of being a programmer. I just stand by for more than a year. That's why i need help because im working back now of being a programmer.
Any help would be appreciated.
thanks in advance...
Good day!
I have a problem regarding to my MSSQL db. I have a database name named db1 with huge structure of tables and has a series of data also.
I would like to copy the db1 to the newly created db. with the db1 tables structure and data. In other words, i just want to duplicate it. May i know whats the right code for this? By, the i'm using microsoft SQL server 2005 and mssql server studio. Is there any short cut to duplicate a db to another db with the same server?
I'm just a returnee of being a programmer. I just stand by for more than a year. That's why i need help because im working back now of being a programmer.
Any help would be appreciated.
thanks in advance...
Comment