Welcome to Sign in | Help

Re: Plan de upgrade

  •  11-17-2006, 11:24 PM

    Re: Plan de upgrade

    Pentru ca sunt 1354 de baze de date, inainte de operatia descrisa mai sus creati un script prin care generati 1354 de comenzi de genul(in 2000) :

    CREATE DATABASE MyAdventureWorks 
        ON (FILENAME = 'C:\MySQLServer\AdventureWorks_Data.mdf'),
        (FILENAME = 'C:\MySQLServer\AdventureWorks_Log.ldf')
        FOR ATTACH;
    
    Cum asta ? cam asa:
    select 'Create database ',name ....... from sysdatabases
     O discutie despre atasarea unei bd intr-un articol aici

    Gheorghe Ciubuc,SQL Server Influencer, MCP(SQL 2000), MCTS (SQL Server 2005) , OCA(Oracle 9i), Sybase(Brainbench)
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems