Merging server database with portable database
-
Hi. i am currently building a project that contains data on a SQL server (2008), i need to move some data from the server to a portable media (like SDF file or access file), the structure in both are the equal. at certain queries i will want to query both databases , the server and portable one (so only one who has the portable database on the USB can get true results). can anyone tel me which format would be the easiest to deal with this? for example is there a format that i can use to attach to the database and create a UNION query that should query the server and the file at once? is it "healthy" to use a MDF file as the portable database and attach and deattach every time i want to use the database and then create a UNION query to the servers database?
-
Hi. i am currently building a project that contains data on a SQL server (2008), i need to move some data from the server to a portable media (like SDF file or access file), the structure in both are the equal. at certain queries i will want to query both databases , the server and portable one (so only one who has the portable database on the USB can get true results). can anyone tel me which format would be the easiest to deal with this? for example is there a format that i can use to attach to the database and create a UNION query that should query the server and the file at once? is it "healthy" to use a MDF file as the portable database and attach and deattach every time i want to use the database and then create a UNION query to the servers database?