How can we export all data of one database server that is running and how can we've got the guarantee that all is synchronized between both servers.
The point is that the client need to pass all databases of one "semi development server" (i tell you semi dev server because this server is now the production server), but the customer does not want to have non-availability of databases, is this possible?
In the origin the biggest database is made of one datafile of 100GB :crazy:, but in the destiny we want to store data/index(all content of database) in other 10 datafiles that we'll create one of each with 10GB.
How can we ensure that tables and indexes will be created in these datafiles?
Thanks and regards,
JMSM 😉