SolvedPrivate

Creating and importing data into a database using .sql files

Posted on 2013-11-13
4
56 Views
Last Modified: 2016-02-11
We have created a new CRM deployment and pointed it to a new back end database that is running SQL Server 2008. We also have an existing deployment on SQL 2008 R2, which I would like to use a database off to test the new environment. The problem that I have is that the smallest database is 20GB, so when I script it out and convert it so that it is compatible with 2008 it is roughly 34GB in size, which means when I try and import it the .sql file it says there are not enough resources available. I have then exported it in several files (over 2000) and transferred them to the new server.

My question is - How do I know what order the new files should be imported in?

Any assistance would be appreciated
0
Comment
Question by:TVS-ServiceDesk
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 27

Expert Comment

by:Chinmay Patel
ID: 39645161
I dont think you can do it this way. Did you try to import the database directly.
0
 
LVL 27

Accepted Solution

by:
Zberteoc earned 500 total points
ID: 39645298
You can try this:

1. Like you said, generate a script with both structure and data for all your objects in the database (with create database option if the database doesn't exist on the target server) into 1 big .sql file, which then you will have to execute on the target using the SQLCMD utility from a command prompt window:

C:>sqlcmd -S myServer\instanceName -i C:\myScript.sql -E

2. Use the import export feature on any of the servers.

3. Use SSIS

4. Use snapshot replication
0
 
LVL 27

Expert Comment

by:Chinmay Patel
ID: 39645840
Please try taking the DB files and try an upgrade. CRM doesnt allow direct database manipulation. Make sure you have all the required backups befor you try anything.
0
 

Author Closing Comment

by:TVS-ServiceDesk
ID: 39692611
This worked a treat, thankyou very much for your assistance
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

My client sends data in an Excel file to me to load them into Staging database. The file contains many sheets that they have same structure. In this article, I would like to share the simple way to load data of multiple sheets by using SSIS.
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question