August 29, 2008 at 10:02 am
Could someone point me in the right direction? I have a database that was created for an application a few months ago, started using it, it's great but now we are adding to it, changing the tables swapping columns. Where can I go look and find out how to save the data we already have, and convert to this new set of tables.
Sorry if this is a no brainier question, but I am fairly new to SQL and databases. 🙂 thanks in advance
[font="Comic Sans MS"]Being "normal" is not necessarily a virtue; it rather denotes a lack of courage.
-Practical Magic[/font]
August 29, 2008 at 12:24 pm
Normally you would have at least a development environment and a production environment and when you have tested all your changes you load the production data into the development database and then move the development database to production. Having taken a full backup of the old database first.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 29, 2008 at 1:53 pm
yes i do have that set up
[font="Comic Sans MS"]Being "normal" is not necessarily a virtue; it rather denotes a lack of courage.
-Practical Magic[/font]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply