Hi,
I'm considering moving my database from access to sql server.
I have several databases that the FE/GUI links to. Some are local based and some are on a server.
When I move to SQL server, can I keep this same structure, and use multiple odbc files to connect all of the databases? Or is there a better method.
I think I would prefer to keep separate databases for information. Rather then write procedures to upgrade the database, sometimes it's easier to just distribute a new one.
-Mark
Mark P.
Providing Low Cost Powerful Point of Sale Solutions.
I'm considering moving my database from access to sql server.
I have several databases that the FE/GUI links to. Some are local based and some are on a server.
When I move to SQL server, can I keep this same structure, and use multiple odbc files to connect all of the databases? Or is there a better method.
I think I would prefer to keep separate databases for information. Rather then write procedures to upgrade the database, sometimes it's easier to just distribute a new one.
-Mark
Mark P.
Providing Low Cost Powerful Point of Sale Solutions.