[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Private
  • Views: 63
  • Last Modified:

Creating and importing data into a database using .sql files

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
TVS-ServiceDesk
Asked:
TVS-ServiceDesk
  • 2
1 Solution
 
Chinmay PatelEnterprise ArchitectCommented:
I dont think you can do it this way. Did you try to import the database directly.
0
 
ZberteocCommented:
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
 
Chinmay PatelEnterprise ArchitectCommented:
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
 
TVS-ServiceDeskAuthor Commented:
This worked a treat, thankyou very much for your assistance
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now