Add the name of the History database to the Local column of the entry for the History database (something like “Database_History”) Right-click the main SQL project and go to Properties -> SQLCMD VariablesĪ.Periods are not supported in the variable name. Replace any periods in the Database variable with underscores. The database location is “different database, same server”Ĭ. Database reference to a project in the current solutionī. Add a database reference to the main database that points to the history databaseĪ.Repeat steps 1-3 above for the History database (IF available).Select the database you want to import and click Start.Right-click the new SQL project and choose Import -> Database.
3 Comments
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |