JaedenRuiner
Well-known member
- Joined
- Aug 13, 2007
- Messages
- 340
- Programming Experience
- 10+
Okay,
Well, i know this was probably a "Bad" thing to do, but I created a database on my system, the development system, and wrote my application to use it while I waited for our IT department to install SQL Express on the database server.
Now that is done, we have a "local" copy of the database that is currently being used for the application, but within a few weeks, we will be switching to the Networked Copy.
How I got a networked copy is where the "bad" part comes in, because I simply detached the database from my server, copied the files over, and the attached those files back into the other server. But that was just to copy the structure so i had the database on the other server, but it was an older copy while I administer and configure the server to react the way we want/need for the application.
However, I currently no longer have access to those directories on the database server system from my location, and I will need to copy the "data" from all my tables that are in my local copy to the one on the server. the question is how?
Is that called 'migration' or 'replication', though i don't think its the later just from semantic understanding of the term...but I'm not sure about what I would do an how. I figure I could possibly use a SQL connection, or perhaps write a VB applicaiton that would copy the data, but I am sure there is another way to go about this.
Thanks
Well, i know this was probably a "Bad" thing to do, but I created a database on my system, the development system, and wrote my application to use it while I waited for our IT department to install SQL Express on the database server.
Now that is done, we have a "local" copy of the database that is currently being used for the application, but within a few weeks, we will be switching to the Networked Copy.
How I got a networked copy is where the "bad" part comes in, because I simply detached the database from my server, copied the files over, and the attached those files back into the other server. But that was just to copy the structure so i had the database on the other server, but it was an older copy while I administer and configure the server to react the way we want/need for the application.
However, I currently no longer have access to those directories on the database server system from my location, and I will need to copy the "data" from all my tables that are in my local copy to the one on the server. the question is how?
Is that called 'migration' or 'replication', though i don't think its the later just from semantic understanding of the term...but I'm not sure about what I would do an how. I figure I could possibly use a SQL connection, or perhaps write a VB applicaiton that would copy the data, but I am sure there is another way to go about this.
Thanks
