Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-20 : 09:47:19
|
| Jayanta writes "actually i am making a year end transfer programme . i want to make a new database for the next accounting year which will have all tables , views, stored procedures,triggers coppied to the new database with the primary key and indexes from the previous year database which is on the same server and user , programatically . expecting a quick response ." |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2002-03-20 : 10:02:31
|
| don't EXPECT anything....help given here is done so FREELY....we all have our own (paid) work to do as well!!!to copy a database structure, minus the data using a tool....take a look at www.redgate.com....and their SQL Compare tool. Cheap, quick, efficient, reliable.other ways of doing same, may be to 'script all database objects' via EM. |
 |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-03-20 : 10:13:04
|
quote:
expecting a quick response ."
 a DTS package might be an attractive option for you. read up on the Copy SQL Server objects task.setBasedIsTheTruepath<O> |
|
|
|
|
|
|
programatic table and other objects transfer from on database to another database