Comments
Sort by recent activity
I have a similar problem. I want to create an insert sql file of the data in my database and send it to a client for them to run on their database.
I compared a blank instance of the database to its current state and the sql file generated is 210MB. I ran the query from the command prompt, here is the statement: osql -E -d [database_name] < [script_file_name]. The query was just chugging and showed progress but was taking way too long, after 15 hours I gave up.
I must be doing something wrong since it takes me only 2 hours performing operations with the UI of my application to generate this exact same data. I assumed that doing a straight SQL dump would be much faster. Do I even have the right software for what I need? / comments
I have a similar problem. I want to create an insert sql file of the data in my database and send it to a client for them to run on their database.
I compared a blank instance of the database to it...