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 |
|
anjan
Starting Member
21 Posts |
 Posted - 2006-03-17 : 15:25:58
|
| Hi All,I want to create database from existing database.But i want it done my VB Application.My requirement is, i have "DB1" databse in my server which i'm using now for my application, now i want this same database as "DB2" on the same server.Later i perform some other year ending operations on DB2 Databse and use this databse for the next accounting year.Note: Every Accounting year will have one database.what are the ways to do...Please help regarding this... I expect reply from u soonThanks.... |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-03-17 : 15:30:51
|
quote:
Originally posted by anjan...I tried ...but i failed...
What did you try, and how did it fail?CODO ERGO SUM |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-03-17 : 20:44:12
|
Post your create database codes / scripts."Note: Every Accounting year will have one database."Have you really give it a thought about this ? This does not sound like a good design. Isn't it easier to have all transaction under same database and have a column to identify the year ?
KHChoice is an illusion, created between those with power, and those without.Concordantly, while your first question may be the most pertinent, you may or may not realize it is also the most irrelevant |
|
|
|
|
|
|
Create Database at Runtime