I am getting ready to start my project of moving our current Access database data to sql server. I currently keep a "Development" version of the database on my computer and the "Live" version on our network server. if I create the new sql database on sql server on my computer, Will it be easy to move the new set of tables to the "Live" sql server running on our network server? I hope my question makes sense.
Kevin Yip
@Reply 5 hours ago
Is the live version in use by other users while you are making changes to the dev version? If so, then you and your users cannot make changes to the same tables in the dev and live versions. If that's impossible to do, then my advice is don't go live until you finish all your developmental work. After you go live, if you want to make changes again, put the live server offline, make changes, then put it back online when you finish.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
