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 |  
                                    | code.mafiaStarting Member
 
 
                                        1 Post | 
                                            
                                            |  Posted - 2007-04-17 : 21:25:54 
 |  
                                            | Can I copy a database (structure, keys, relationships, data) that I create in SQL Express to a regular SQL Server database?  If so, whats the best way to do it? |  |  
                                    | tkizerAlmighty SQL Goddess
 
 
                                    38200 Posts | 
                                        
                                          |  Posted - 2007-04-18 : 00:10:14 
 |  
                                          | Yes.  The best way is to backup the database in express, if necessary copy the file to the regular server, then restore the database onto regular sql.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |  
                                          |  |  |  
                                |  |  |  |