Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    Join Date
    Nov 2003
    Location
    FRANCE
    Posts
    393

    Unanswered: Master and new database

    Is there an easy way of "linking" a new database file to the Master ?

    By sp_attache_single_file_db or sp_attach_file ?

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: Master and new database

    Why in the world do yo want to do that?

  3. #3
    Join Date
    Feb 2002
    Posts
    2,232
    Are you trying to attach a database from another sql instance ? When you say new database file - what do you mean ?

  4. #4
    Join Date
    Nov 2003
    Location
    FRANCE
    Posts
    393
    First of all, you have to know that I'm migrating a VB-Sybase programs to VB-SQLServer.

    I've got a program that creates databases for new users and load them with the good data. This is done on SQLServer1.

    The database (for example A.mdf) created is sent on SQLServerA
    then the VB program must reattach A.mdf to SQLServerA.

    I think it's the command :

    EXEC sp_deattach_db 'A', 'true'

    that I have to use but when I try this in the Query Analyser
    it says that I have a connection on A.

    Is there a command to disconnect a specified database

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    A database per user....

    hmmmmmmmm.....the logistics.....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  6. #6
    Join Date
    Nov 2003
    Location
    FRANCE
    Posts
    393
    there is 2000 users dispatched through out France
    that's the principale reason

  7. #7
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Are you talking about msde?

    If not, WOW 2000 dbs? On one instance?

    Just curious, how big are the databases going to be, and what are they for?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  8. #8
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Originally posted by Brett Kaiser
    If not, WOW 2000 dbs? On one instance?
    That about sums up my reaction too.

    2000 db's on one instance !!! ... have handled big dbs ... but never in numbers .. only in size
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  9. #9
    Join Date
    Nov 2003
    Location
    FRANCE
    Posts
    393
    In short :

    I work in a Insurance compagny and
    each sales person has a laptop with the info of their clients

    The main DB2-database (all the clients) is at the head office of the compagny.
    Each week, a program turns to create the databases of all new users (new sales persons).
    Each month, the data of each database is regenarated from the DB2.
    Each day, the updates from the users are integrated in the DB2.

    The exported and imported data transit on phone-lines.

  10. #10
    Join Date
    Nov 2003
    Location
    FRANCE
    Posts
    393
    Therefore there is only one database on each laptop

    1 DB = 1 person

  11. #11
    Join Date
    Feb 2002
    Posts
    2,232
    So does each laptop have sql server ?

  12. #12
    Join Date
    Nov 2003
    Location
    FRANCE
    Posts
    393
    yes

    that's why the compagny wants to switch from Sybase to SQL Server
    Tere will be less licences to pay
    $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$

  13. #13
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    huh?

    Are you sure you're not talking about Access or MSDE?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  14. #14
    Join Date
    Nov 2003
    Location
    FRANCE
    Posts
    393
    oups, yes you're right >>> MSDE

  15. #15
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    If this is not a reason for a wireless solution...I don't know what is...

    2000 dbs...download over phone lines...synching back to DB2 (OS/390?)

    the horror...the sheer horror
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •