Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Adam West
Constraint Violating Yak Guru
261 Posts |
 Posted - 2009-07-28 : 10:36:01
|
| We use MS Great Plains. I have a test system I have been using and they have some bad data in there. I have asked for a refresh. Now I have also created a couple of stored procedures, views, and a table of my own. Also put in some data that was lacking.When they update me, is this going to wipe out what I have added? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-07-28 : 13:04:33
|
That depends on how the update will be done.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2009-07-28 : 14:44:32
|
| A restore will definitely overlay all your modifications to that particular database. Did you ever think about a separate database for any new code introduced and then use 3 part naming convention to affect the appropriate company within the application (with the same database setup on the production server)?Terry-- Procrastinate now! |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-07-28 : 14:49:33
|
Maybe he has procrastinated...
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
Adam West
Constraint Violating Yak Guru
261 Posts |
Posted - 2009-07-28 : 14:57:52
|
| Separate db sounds like the way to go. |
|
|
|
Adam West
Constraint Violating Yak Guru
261 Posts |
Posted - 2009-07-29 : 09:26:14
|
| How would I refer to the say table view if it's in another database?My report uses a table view based on the database A, now you are saying I should make this table view in database custom. How does the report make the link? |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Adam West
Constraint Violating Yak Guru
261 Posts |
Posted - 2009-07-29 : 11:47:02
|
| Great Plains is now part of Microsoft Dynamics. We use the accounting and Financials. |
|
|
|
|
|
|
Update to a Database