I am responsible for upgrading an old SQL 2000 database (and related processes) to SQL 2014. Our corporate database team helped a bit by transferring it over to a SQL 2008 Express database, which they said was a necessary step. I can back up and restore the 2008 db to 2014 no problem, but my issue is this: during development and testing, I need current data from the production SQL 2000 db. What is the proper way to refresh the SQL 2014 database with SQL 2000 data? Do I have to use the SQL 2008 Express db as an intermediary? Any info and details appreciated.
Note that each database is on its own Wintel server on the same domain, and I have full permissions to all. Thx.